IF Function

[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

 

[Arvi Laanemets]

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)

 

[Fakhruddin Zavery]

Thanks ARvi,

It worked out just perfect.

Regards
Fakhruddin