Excell Help

Please clarfity how the "mulitply by 0" is utilized.

there are 2 formulas shown for F2 and a value of F2=0. Perhaps (J51*5%) is intended as the formula for E2 instead of F2?

Maybe an IF statement would stop the negative. Something like:

=IF( 'cell with value' = 0 , 0 , 'formula' )

excel
sorry, it should be E2 instead of F2

Excel
what I'm trying to find out is how to write a formula that if multiplied by zero will not give me a negative answer.

I have five columns:

column A1 is total = 81
column A2 is Actuals (DBR) = 4
column A3 is 5% of total =4 the formula is =(A1*5%)
column A4 is # of units over 5% = 0 the formula is =(A2-A3)
column A5 is Chg Back = -5.25 the formula is =(a4*$105)

How can I get column A5 to not show a negative, just a zero if the result is a negative number?

I'm lost. I just set up a test case. Actually, I multiplied a cell containing the value "5" by one containing a zero. As expected, the result was 0, with no minus sign. Are we all missing something in the question?

Exel Help - Seasoned Member
Hello Seasoned Member, I sent you an email to your yahoo address with the file.

Thank you.

I didn't open the attachment, but replied with my new understanding of the question. Basically, I answered the same as a the Grand Duke, but in slightly different language.