2 =IF conditions

  • Thread starter Thread starter BetaDocuments
  • Start date Start date
B

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.
 
=if(a1="in","officer",if(o14>1000000000,"dual vp",if(o14>500000000,"vp",
if
(o14>100000000,"avp", "officer"))))
Click to expand...

Excellent. Thanks a bunch for the help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

two =if(xyaz,lki) conditions help 2
how many inbedded if statements can i have? 5
Complicated Cell Formula 9
Sum or Average with #N/A cells 5
Problem with AND function 2
Need better macro 3
Copy FormulaArray 7
SUM, AVERAGE and PRINT with #N/A cells 11

Back
Top