Problem around IF statements for multiple conditions
Hello everyone.
I'm trying to insert a formula where I want to return a value based on
I107 being greater than C1
If cell R107 =BL than U107*-1
If cell R107 =SL than cell equals U107
Any ideas on how to do this. Included my formula
=IF(AND(I107>$C$1,OR(R107="BL",R107="SL")),U107*1,U107*-1)
But its not working. :-(
Last edited by kris01; 05-22-2019 at 12:28 PM. Reason: Amend title
Try this is A107
Formula:
Please Login or Register to view this content.
I did not understand how you got the mix of AND(...OR(...)) logic out of your description. It might be good debugging practice to use the Evaluate formula tool (https://support.office.com/en-us/art...6-a70aa409b8a7 ) and see how Excel evaluates your function.
I would have expected two separate IF() functions nested together, where one IF() condition tests for "after the end of the month" and the other IF() condition tests for BL/SL. Maybe something like =IF(I107>$C$1,U107*IF(R107="BL",-1,1),"Before month end") Note that I am assuming that "BL" and "SL" are the only possible values for column R.
Originally Posted by shg
If R107 have only the values SL and BL you can simplify the formula
Formula:Please Login or Register to view this content.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Thanks that worked perfectly.
What would be my formula if I just wanted the below
I107 being greater than C1
If cell R107 =BL than "Creditors"
If cell R107 =SL than "Debtors"
if cell R107 =CS that "Debtors"
Thanks for the tip dude. Got myself in a right muddle and got confused.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks