Joined: 31 Dec 2008
Location: Bournemouth, England
|Posted: Wed Dec 31, 2008 9:42 am Post subject: Multiple IF conditions
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!!!