| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND) function?
Thanks so much for your help! It works!!
"cindyb" wrote: Does Excel have the ability to calculate the following" I have a calculated value in cell A51. If that calculated value is in the range of numbers in the first column below, I need a formula for Excel to return the value in the second column below to cell A60. 0 - 500,000 250 500,001 -750,000 300 750,001 - 1,000,000 350 1,000,001 - up 400 Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
