I think i am completing this wrong. Trying to complete the OR IF on scheme 4 and this can be seen in the attcahed file. I am using a macbook and unsure of how to bring up the if box. I also dont know how i get the answer to multiply 15% by both outcomes. I am not looking for a 'true' 'false' answer, but a calculated bonus.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Need helping doing IF Formula using OR on macbook
0
Answers
0
I have to admit that I don't know which "scheme 4" you refer to, nor can I imagine what an "IF box" might be - perhaps because I don't have a Mac. But I do know the IF statement in Excel which you can [LINK URL="Excel IF Statement – How to Use (exceltrick.com)]"learn here[/LINK]. (Sorry, I can't get this link to work as it should. Just Google for "Excel IF statement" and take any of the results.)
The OR statement consists of a series of conditions that returns TRUE if any of the expressions in it are true. For example,
=OR(2>3, 3=4, 4>3)
evaluates to
=OR(FALSE,FALSE,TRUE)Therefore the overall result is TRUE.
You can build the OR statement into an IF statement in place of a simpler expression for evaluation.
=IF(OR(2>3, 3=4, 4>3),TRUE,FALSE)This function will execute the TRUE part of the IF statement because the OR statement evaluates to TRUE.
By the way, the AND statement works exactly like the OR statement except in it all expressions must evaluate to TRUE, not just one.
UPDATE (in response to your file) =============================
This looks like a task from school. Therefore the answer I gave above is exactly what you should have.
Your syntax in D28 is correct. Therefore, if the result doesn't agree with your excpectations look at the logic of the expressions.
In a nested IF statement, the False result is replaced with another IF statement (this one nested into the first). So, the logic will be: IF the first condition is True, give one result, Else, if another condition is True, give another result, but if that second condition is False give a default result. That second False could again be an IF statement with a third condition - up to 7 deep.
The way to construct nested IFs is to construct each one in its own cell for testing and then copy/paste.
[one cell] =IF(D4>=D13,True,False)
[another cell] = IF(D9>=D14, True, False)
[Combined] =IF(D4>=D13,True,IF(D9>=D14, False, True))
The second IF statement took the place of the bold False in the first. That's how the double closing parentheses came about.