Ignore a cell used in a formula if it contains a negative value
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
|