HI I am trying to combine 3 if statements in one but the order keeps coming out wrong.
The three statements separately are
If (B10>A1,0)
If(B10=A1,-B9)
If(B10<A1, B9+b8)
Can anyone help put these into one statement.
Thanks
HI I am trying to combine 3 if statements in one but the order keeps coming out wrong.
The three statements separately are
If (B10>A1,0)
If(B10=A1,-B9)
If(B10<A1, B9+b8)
Can anyone help put these into one statement.
Thanks
Try
=IF(B10>A1,0,IF(B10=A1,-B9,B9+B8))
great thanks!!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks