IF Function

  • Thread starter Thread starter Fakhruddin Zavery
  • Start date Start date
F

Fakhruddin Zavery

Hello,

I want to use the IF function to perform certain calculation based on a
value in a cell. I can manage that without a problem however my problem
comes up when i want to use a range using OR within IF

Lets say you have A1 with a value and you want certain value to be
calculated based on it.
IF A1 < 50,000 then it should do something but IF A1 is greater than 50,000
BUT less than 180,000 then it should do something, however IF A1 is greater
than 180,000 and less than 250,000 then is should do something.

I can manage the first bit but failing with the second comparison. Here's a
sample of what i was trying to do including hte OR bit but failing.

=IF(B3<=50000,0,IF(OR(B3>50000,B3<180000)*(B3-50000)*0.185,IF(B3>180000,24050+(B3-180000)*0.2,IF(B3>360000,60050+(B3-360000)*0.25,0))))

Will appreciate all the help

Thanks and Regards
Fakhruddin
 
Hi

=CHOOSE(MATCH(B3,{0;50000;180000;360000},1),0,(B3-50000)*0.185,24050+(B3-180
000)*0.2,60050+(B3-360000)*0.25)
 
Back
Top