=IF(O141000000000,"DUAL VP",IF(O14500000000,"VP", IF
(O14100000000,"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(o141000000000,"dual vp",if(o14500000000,"vp",
if
(o14100000000,"avp", "officer"))))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54822

On Jan 26, 3:27*pm, JBeaucaire
wrote:
=if(a1="in","officer",if(o141000000000,"dual vp",if(o14500000000,"vp",
if
(o14100000000,"avp", "officer"))))

--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:http://www.thecodecage.com/forumz/member.php?userid=73
View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=54822

Excellent. Thanks a bunch for the help.

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.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54822