Forum Discussion
IF statement plus a calc
Column 1 - This may have a %, not applicable if it does not
Column 2 - flat number
Column 3 - flat number
Column 4 - flat number
Column 5 - Equals 2, 3, 4 together
Column 6 - Total need help here
I need for column to do the following:
If there is a % in 1 then take % * 200 = X then take column 5 if greater then that number return 0 or If column 5 is not greater than that number then return difference. If no % in column 1 then do rest of calc.
How do I do this?
1 Reply
It's not clear what you mean by "If no % in column 1 then do rest of calc."
Perhaps, in F2:
=MAX(200*A2-E2,0)
or
=IF(A2="",E2,MAX(200*A2-E2,0))
