Forum Discussion
Excel Formula, combining two IF statements
I need to string together two IF statements, =IF(C7>=70, C7*0.5) and =IF(C7<=69, C7*0.65), please help
I see, thank you for the clarification. It could be
=IF(
E3=7.5,
IF(B3<=50,20,30),
IF(E3=15,
IF(B3<=50,30,40),
0
)
)
Ahhh, bliss - THANK YOU so much.
I wish I could return a favour, but still in learning mode. You have saved me hours of work!
MarieHelena , you are welcome
- Dear all,
I need a help with two if function in one cell.
I must take details from two sheet, and for that reason, use one if function. Another if function I need for keep clear cell with error example #N\A
=if(a4="","") =if(g4="crew",""),if(g4="pax",vlookup(a4,pax!a:u, 5,false))
I must prepare functions in whole sheet but if I don't type argument in cells always show error msg #N\A
Thanks,
SinisaPerhaps you mean
=IF(A4="","", IF(G4="crew","", IF(G4="pax", IFNA(vlookup(a4,pax!a:u, 5,false), "can't find"), "wrong combination" )))
