Nested if formula

[webmax]

Hi

Kindly find the attached and help in solving the formula

regards
sham

 

[Naresh Yadav]

pls try this..

=LOOKUP(B12,{0,1000,2000,3000},{"West","East","North","South"})

 

[bosco_yip]

Another option.

In C2, copy down :

=TEXT(0&B2-1000,"[>1999]\Sout\h;[>999]\Nort\h;\Ea\st;W\e\st")

Or,

=CHOOSE(B2/1000+1,"West","East","North","South")

Regards
Bosco

 

[Sukhdev Singh]

Please try Lookup as used in attached sheet. Hope it will help you.

thanks,
Best Rgds,
Sukhdev Singh

 

[XLPadawan]

Lions, tigers, bears, and helper cells, oh my! Who knows, you may like it.