View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default Formula Modification

This formula works okay when cell U51 is either blank or
with data greater than zero; however, I now need to modify
the formula for the case when cell U51 has a zero posted
in it - so it returns a zero answer - with the other
features still intact.

=IF(U51<0,(U51-V42)/(P42-V42),"")