Thread: Continue formula to LINE 1000 without showing FALSE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chieron
 
Posts: n/a
Default Continue formula to LINE 1000 without showing FALSE
I have a formula to recognise if "yes" and "no" - when I copy this formula
down from say line 26 to line 1000 I get a run of FALSE

The formula I'm using is =IF(I13="yes",SUM(C13:F13)-G13,IF(I13="no","0"))
and this works fine when I put in 'yes' or 'no' but were it is left blank I
get FALSE continuously running down from line 26 to line 1000.

Can you help??

Reply With QuoteReply With Quote