IF Farmula in Excel

This query is : Resolved

Report Abuse 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.

Upgrade to CAclubindia Pro. Subscribe Now!

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