IF Farmula in Excel
This query is : Resolved
18 October 2010
HOW CAN I GIVE ONE FORMULA OF THIS
IF(A1=B1,C1,D1) OR IF(A2=B2,C2,D2) OR IF(A3=B3,C3,D3)............
IF(A1=B1,C1,D1) OR IF(A2=B2,C2,D2) OR IF(A3=B3,C3,D3)............
19 October 2010
your question is not clear. please ask in foum section and attached your file for example. so expert can solved your problems.
19 October 2010
https://www.caclubindia.com/forum/total-formulas-in-excel--105971.asp
Please see this forum post. You will find useful files containing all excel formulas.
Please see this forum post. You will find useful files containing all excel formulas.
19 October 2010
Data Taken in Excel is as follows >
A1 1(D8) A2 2(F8)
B1 5(D9) B2 1(F9)
C1 2(D10) C2 2(F10)
D1 3(D11) D2 3(F11)
Formula Used
IF(OR(D8=D9,D8=D10,D8=D11),D8,IF(OR(F8=F9,F8=F10,F8=F11),F8,0))
Check if it works for you.
Regards
A1 1(D8) A2 2(F8)
B1 5(D9) B2 1(F9)
C1 2(D10) C2 2(F10)
D1 3(D11) D2 3(F11)
Formula Used
IF(OR(D8=D9,D8=D10,D8=D11),D8,IF(OR(F8=F9,F8=F10,F8=F11),F8,0))
Check if it works for you.
Regards
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GSTR-1A How to update Invoice
- Excess salary payment.
- Stamp Paper for partnership firm change new income tax 2025
- Capital gain from sale of house property
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- TDS on Purchase of Immovable Property by NRI from NRI
- INTEREST APPLICABLE ON ITC REVERSAL PORTION
- Regarding TDS Applicability For Director Remuneration
- Value of property in capital gain
- FORM 26A APPLICABILITY
- Copyright software
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
