Hi,

I thank you for answering my question. Can I change count to sum? the cells
are all numeric.
--
thank you mac


"T. Valko" wrote:

Try this (all on one line):

=IF(AND(COUNTIF('WS A'!C75:C83,"0"),
COUNTIF('WS S-3,II'!D17,"0")),"No variance",
"Must enter hours for reported salaries")

--
Biff
Microsoft Excel MVP


"mac" wrote in message
...
Hi,
If any cell in the range has a number in it. Thank you for replying to
my
question.
--
thank you mac


"T. Valko" wrote:

If WS A cell C75:C830

Does that mean *every* cell in the range is 0 or *any* cell in the range
is
0?

--
Biff
Microsoft Excel MVP


"mac" wrote in message
...
Hello,

I am having trouble with this formula

If WS A cell C75:C830, then WS S-3,II cell D17 should be 0. If true,
"No
variance". If false, "Must enter hours for reported salaries"

Any help will be greatly appreciated

Thank you

--
thank you mac