View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cindyb
 
Posts: n/a
Default IF(AND) function?

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.