Forum Discussion
Nested IF/OR
Hello im trying to use a formula for figuring out if a bonus will be paid if sales or the operating profit target is met, its wanting a nested if with or function in it, im struggling as im new to the course and im not getting help. any help is appreciated. This is what i have for my normal if formula with or in it, =IF(OR(D4>=D13, D9>=D14), 0.1*D9, 0)
2 Replies
In this Excel forum, we generally have agreed not to answer homework questions for people taking classes in Excel. Homework is given so that you work to figure it out.
That said, your formula looks fine as it stands. It may not meet each of the four conditions specified in the task, but its syntax looks to be fine. If it needs to be altered for other conditions, that is part of your homework.
- I agree with mathetes to not do others homework but will help people the same as how I might help them if I was the professor or a TA. So this exercise appears to be how to form nested IF() statement that are the same a use AND or OR functions. So here are a couple examples:
=IF(A, IF(B, ans, 0), 0)
=IF(A, ans, IF(B, ans, 0))
where A and B are conditions and 'ans' is the answer/output. If you walk through those 2 examples I think you will find them to be helpful
