IF question

hankyknot · Newbie Joined: 14 Sep 2007 Posts: 1

I am trying to get a calculation that in plain english does the following

IF D3 is less than 100 then the answer is 5, IF D3 is between 101 & 150 then the answer is 10, IF D3 is greater than 150 then the answer is D3 * .07

I can get a single true/false IF statement with no problem but including the 3rd factor is proving difficult. I have googled for an answer but cannot find one.

Any ideas

willow · Posted: Fri Sep 14, 2007 4:06 am Post subject: Nest the IF's

If I understand your problem correctly you need to nest the "IF" tests.

Start with the highest condition ( > 150 ) and if it passes that test get the result. If it fails then use another IF to do the second and third part.

=IF(D3>150;D3*0.7;IF(D3>100;10;5))

Hagar Delest · Posted: Fri Sep 14, 2007 5:07 am Post subject:

I'd made a quick description about exactly the same issue here : [SOLVED] Help with IF statement.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.
_________________
Now on the EN user community forum