One way

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon




"Donald Thomas" <Donald wrote in message
...
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