Sum If Function

  • Thread starter Thread starter harts56
  • Start date Start date
H

harts56

Assume A1 to be cell in question, second cell (say L1 just for arguemen
sake) to have formula to compute the following:
If A1 is 0, them 0 to show
If A1 is between 1-50000, then 50 to show
If A1 is over 50000, then 100 to show

Any takers on this?

Thanks,

Joh
 
=IF(A1=0,0,IF(A1<=50000,50,100))

Assumes your numbers are integers else you need to cater for between 1 and 0.
 
Back
Top