Forum Discussion
RobDouglas
Apr 12, 2023Copper Contributor
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 th...
mathetes
Apr 13, 2023Gold Contributor
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.
mtarler
Apr 13, 2023Silver Contributor
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
=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