Multiple IF conditions

phil1986 · Posted: Wed Dec 31, 2008 9:42 am Post subject: Multiple IF conditions

Hello,
Quite a simple question I think, but I'm a newly converted OO user from Excel.
I tried to search in the forum, but couldn't find anything.

In Calc, I need a formula in cell G5 that does the following:

IF E5 <= 0, return £0
IF E5 > 0 but <= 500, return £50
IF E5 > 500 but <= 1000, return £100
IF E5 > 1000, return £150

Thanks if you can help me out.

And have a HAPPY NEW YEAR!!!

David · Posted: Wed Dec 31, 2008 11:32 am Post subject:

If statements are parsed from left to right until a truth is found:

=IF(E5<=0;0;IF(E5<=500;50;IF(E5<=1000;100;150)))

Happy New Year to you also.

David.