Formula Problem
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
|