formula checking if all cells are greater than x
Hi,
If all cells will contain numbers, no blanks and no text then
=IF(MIN(A1:D1)3,"All","No")
otherwise the slightly modified version of Mike's to match your request:
=IF(COUNTIF(A1:D1,"3")=4,"All","No")
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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?....
|