| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?.... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?.... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS BLANK checking 2 Cells | Excel Worksheet Functions | |||
| Checking cells for 2 conditions | Excel Worksheet Functions | |||
| Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
| Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
Linear Mode
