formula checking if all cells are greater than x
See what I mean?
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
That is *the* perfect solution but let's see what happens.
--
Biff
Microsoft Excel MVP
"Mike H" wrote in message
...
Hi,,
Try this
=IF(COUNTIF(A1:D1,"3")=4,"All","")
Mike
"Tami" wrote:
Hi....
i need a formula that asks if cell A13 and B1 3 and c13 and D13 then
return "ALL", otherwise "No"...in other words if all the cells in A1:D1
are
greather than 3 then "ALL".
anyone?....
|