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 her...
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))