IF-THEN function for many conditions

[ss_bb_24]

Dear all,

I have attached my sheet. I want to apply IF-THEN formula in P1 cell in this condition:-

IF C1=Y then =IF(OR($D$4="",M8=""),0,IF($D$3="USD",J8,IF(J8="na","na",J8/$D$4)))

OR (IF NOT)

C1=N then=IF(OR($D$4="",M8=""),0,IF($D$3="USD",M8,IF(M8="na","na",M8/$D$4)))

Can anyone help me.

[Kieran]

try =IF(C1="Y",IF(OR($D$4="",M8=""),0,IF($D$3="USD",J8,IF(J8="na","na",J8/$D$4))), IF(C1="N", IF(OR($D$4="",M8=""),0,IF($D$3="USD",M8,IF(M8="na","na",M8/$D$4))),"Dont know what to do"))

[ss_bb_24]

Thanks a lot. Its working. But if I want to add one more condition alongwith this. The condition is below:-

If D1="x"
then P1= IF(C1="Y",IF(OR($D$4="",M8=""),0,IF($D$3="USD",J8,IF(J8="na","na",J8/$D$4))), IF(C1="N", IF(OR($D$4="",M8=""),0,IF($D$3="USD",M8,IF(M8="na","na",M8/$D$4))),"Dont know what to do"))

Else P1=0

could you please guide me how can I add one more if-then function with this.

Thanks in advance!!!

[Kieran]

Use

= IF(D1="x", IF(C1="Y",IF(OR($D$4="",M8=""),0,IF($D$3="USD",J8,IF(J8="na","na",J8/$D$4))), IF(C1="N", IF(OR($D$4="",M8=""),0,IF($D$3="USD",M8,IF(M8="na","na",M8/$D$4))),"Dont know what to do")),0)