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