software

I am trying to create a simple formula...=(F40*F28) F30

F30 is a calculated cell. Sometimes it may contain a negative value. When
F30 does contain a negative value I want the formula I am trying to create to
ignor it or use a zero.

Thanks for your help,

Donald Thomas

One way

=(F40*F28) MAX(F30,0)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon

quot;Donald Thomasquot; lt;Donald gt; wrote in message
...
gt;I am trying to create a simple formula...=(F40*F28) F30
gt;
gt; F30 is a calculated cell. Sometimes it may contain a negative value.
gt; When
gt; F30 does contain a negative value I want the formula I am trying to create
gt; to
gt; ignor it or use a zero.
gt;
gt; Thanks for your help,
gt;
gt; Donald Thomas

Peo Sjoblom,

That was FAST and it worked!

Thank you very much,

Donald