Thread: IF'S Blah
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phuser
 
Posts: n/a
Default IF'S Blah

=IF(ISERROR(F16-K16),"",IF(SUM(F16-K160),"",SUM(F16-K16)))

Cells F16 & K16 can either contain a "Null String" ("") or a number created
from another IF statement , from these 2 Cells I need another calculation,
if the error "#Value" is made I want it to be blank, If the number is 0, I
want it to be blank, but if it's a number I want it to appear.

Any help is greatly appreciated