IF statement plus a calc

Copper Contributor

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

@MV0891 

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