Hi,
I want to say, if B1 = A then the value is 10, if B1 = B then the value is 20, if C then the value is 30 and D the value is 40.
If there are two conditions then I know it would be =if(b1=A,10,0) but this is obviously a bit more complex.
Thanks
Matt
Last edited by Gooford; 12-08-2009 at 05:25 AM.
You can use a nested IF.. like so
=IF(B1="A",10,IF(B1="B",20,IF(B1="C",20,IF(B1="D",40,"")
or simpler and more versatile...
=Lookup(B1,{"A","B","C","D"},{10,20,30,40})
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
ace, I had forgotten about Lookup.
Cheers!
Using the Lookup, how do I put in a line to show "" for any inputs other than A B Cor D?
Try:
=LOOKUP(B1,{"A","B","C","D","E"},{10,20,30,40,""})
In the off chance you might have blank or a number in B1, you could change it to
=LOOKUP(B1,{0,"A","B","C","D","E"},{"",10,20,30,40,""})
Cheers thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks