View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donald Thomas
 
Posts: n/a
Default 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