MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If Formulas - HELP


Posted by Maria on November 03, 2001 9:45 AM

Help!! I need a formula for the following:
I have a column of various dollar values in Col A
I want to put a formula in column B that will
enter a dollar value based on the following criteria

If the number in Col A is then enter the following
if Col A then enter
is Between in Col B
0 - 49 ........... 5.00
50 - 99 ........... 10.00
100 - 249 ........... 15.00
250 - 599 ........... 20.00
600 - 999 ........... 30.00
0ver 1000 ........... 100.00


Posted by Mark W. on November 03, 2001 10:47 AM

Use...

=VLOOKUP(A1,{0,5;50,10;100,15;250,20;600,30;1000,100},2)