Range Number decide the size

[choy96]

A1 to C1 got 3 number, if all the number is below 10 , D1 formula will show "Small".
If A1 to C1 number is greater than 10, D1 formula will show "Big"

can i have the formula above.


thanks.

[sweep]

Hi,

How about this:

=IF(MAX(A1:C1)>10,"Big","Small")

[NBVC]

Are are several ways to interpret your question...

Here are 2 more ways

=IF(COUNTIF(A1:C1,"<10"),"Small","Big")

checks that A1, B1 and C1 are all less than 10, if yes, Small, else Big.

=IF(COUNTIF(A1:C1,"<10"),"Small",if(COUNTIF(A1:C1,">=10"),"Big","Mixed")

checks that A1, B1 and C1 are all less than 10, if yes, Small, else if A1, B1 and C1 are all greater than or equal to 10, then Big, else it says "mixed".

Maybe you need to be more specific to your requirements.

[choy96]

wow.... perfect , thanks. sweep and NBVC