LinkBack URL
About LinkBacks
I'm trying to have B1 as "$10.00" if A1 is "firstclass" and B2 as "$20.00" if A1 is "prioritymail" and "$30" for "express"
I tried using the If statement, but it's only for either true or false which is only good for 2 choices.
I'm trying to have B1 as "$10.00" if A1 is "firstclass" and B2 as "$20.00" if A1 is "prioritymail" and "$30" for "express"
I tried using the If statement, but it's only for either true or false which is only good for 2 choices.
You can nest up to 7 IF statements...
Try:
=if(A1="firstclass"=10,if(A1="prioritymail",20,if(A1="express",30,"")))
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.
Another option
VBA Noob=IF(AND(MOD(A1,10)=0,A1<=30),LOOKUP(A1,{10,20,30},{"Firstclass","Prioritymail","Express"}),"")
Last edited by VBA Noob; 06-06-2008 at 02:49 PM.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
What do you want in B1 if A1 is anything else? A blank?I'm trying to have B1 as "$10.00" if A1 is "firstclass"
Please Login or Register to view this content.Same with B2?B2 as "$20.00" if A1 is "prioritymail" and "$30" for "express"
Is this what you want?Please Login or Register to view this content.
ChemistB
yes, you guys are fast!
I think the OP was looking for the reverse... and if so, the LOOKUP() wouldn't work... you would need VLOOKUP() with False trigger...Originally Posted by VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks