excel if then problem?

Question

I am trying to get this formula to work.. Here are the conditions I need all in one cell..

If L5 is > or = m4, then add L5 + M4
If L5 is < m4, then (m4-L5) * -1

so.. basically if number is L5 is greater or equal to M4.. the two need to be added together and that new number needs to be displayed.

but if L5 is less than the value of M4.. then subtrack L5 from M4, then multiply the sum by negative 1.

fathermartin121 · Answer

=IF(L5>=M4,L5+M4,-(M4-L5))
You do not need a second IF statement since it is the IF Not case.
Just a - before the bracket does the same as *-1.

Bill · Answer

=IF(L5>=M4, L5+M4, L5-M4)
-(a-b)=(b-a)

Related Questions