View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default FALSE statement?

If the formulas you posted are the *exact* formulas you're using in your
file it's not possible that either one of them will return FALSE.

Both have a defined value_if_false argument.

--
Biff
Microsoft Excel MVP


"Scoober" wrote in message
...
Can you think of any reason or solution to the FALSE statement?
--
Thanks in advance.

Scoober


"T. Valko" wrote:

There's nothing wrong with either formula so I don't see how a result of
FALSE is even possible.

--
Biff
Microsoft Excel MVP


"Scoober" wrote in message
...
Can anyone tell me why using this formula =IF(COUNT(B35:B38,F35:F38)0,
SUM(B35:B38,F35:F38), "") in my work sheet in F40, combined with
pulling
it
through to my summary sheet with this formula
=IF(OOP!F40="","",OOP!F40)
results in FALSE statement?
--
Thanks in advance.

Scoober