Forum Discussion
I need help with this IF function
I want to C1 to include if B1>A1 give me zero, otherwise give me the difference between the two. I've attached a screenshot.
Example 1 worked with the multiplication scenario. What if the amounts were flipped and 110.35 was A1 and 354.24 Was B1.
=(B1-A1)*(A1<=B1)- Thank you!