IF Farmula in Excel

This query is : Resolved

Share Report Follow Query Ask a Query

Prashant Kumar Gupta

Prashant Kumar Gupta (Querist)
Follow

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)............

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

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.

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

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.

Rahul Gupta

Rahul Gupta (Expert)
Follow

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

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now