Forum Discussion

Copper Contributor

Oct 04, 2017

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

Diamond Contributor

Apr 10, 2021

Perhaps you mean

=IF(A4="","",
 IF(G4="crew","",
 IF(G4="pax",
    IFNA(vlookup(a4,pax!a:u, 5,false),
         "can't find"),
    "wrong combination"
)))

Copper Contributor

Apr 10, 2021

hey Sergei ,
Already fixed. My mistakes was that I had put parenthesis after first argument.
Anyway thanks a lot
Sinisa