formula checking if all cells are greater than x
 

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?....

formula checking if all cells are greater than x
 

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?....

formula checking if all cells are greater than x
 

On 1 Iul, 21:15, Tami wrote:

Maybe :

IF(AND(A13,B13,C13,D13),"ALL","NO")

formula checking if all cells are greater than x
 

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?....

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?....

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?....