Ignore a cell used in a formula if it contains a negative value

D

Donald Thomas

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
 
Top