2 =IF conditions

[BetaDocuments]

=IF(O14>1000000000,"DUAL VP",IF(O14>500000000,"VP", IF
(O14>100000000,"AVP", "OFFICER")))

I what above condition to be true only when Cell A1 is selected "OUT"
and I want OFFICER to appear when "IN" is selected regardless of
amount.


There will be another if but I have no idea how to set it up.


Help will be appreaciated.

 

[JBeaucaire]

=if(a1="in","officer",if(o14>1000000000,"dual vp",if(o14>500000000,"vp"
i
(o14>100000000,"avp", "officer")))

 

[BetaDocuments]

=if(a1="in","officer",if(o14>1000000000,"dual vp",if(o14>500000000,"vp",
if
(o14>100000000,"avp", "officer"))))

Excellent. Thanks a bunch for the help.

 

[JBeaucaire]

Or this layout of the same idea

=IF(A1="IN","OFFICER",LOOKUP(O14
{0,100000000,500000000,1000000000}
{"OFFICER","AVP","VP","DUAL VP"})

...might be easier to read and maintain, up to you