Forum Discussion

Cheryl0615's avatar
Cheryl0615
Copper Contributor
Jul 19, 2024

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.
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 19, 2024

Cheryl0615 

That could be

=(A1-B1)*(A1>=B1)

or

=MAX(0,A1-B1)
  • Cheryl0615's avatar
    Cheryl0615
    Copper Contributor
    Jul 19, 2024
    Example 1 worked with the multiplication scenario. What if the amounts were flipped and 110.35 was A1 and 354.24 Was B1.

Resources