Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing several cells with IF?
I just wanted to know if there is a way that I can check the content of
several cells with a function (possibly IF) to return a value in A1 if the cells referenced all have a specific value. To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates in them. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing several cells with IF?
Hi,
In Excel dates are numbers so try this =IF(COUNT(B1:E1)=4,"R","") Mike "andim" wrote: I just wanted to know if there is a way that I can check the content of several cells with a function (possibly IF) to return a value in A1 if the cells referenced all have a specific value. To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates in them. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing several cells with IF?
A date to Excel is just a number, so it is difficult to check
specifically for dates. However, if you want the value "R" to be returned in A1 if none of the cells are empty, then you can do that this way: =IF(COUNTIF(B1:E1,"<")=4,"R","") Hope this helps. Pete On Jun 16, 11:15*am, andim wrote: I just wanted to know if there is a way that I can check the content of several cells with a function (possibly IF) to return a value in A1 if the cells referenced all have a specific value. To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates in them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Cells | Excel Worksheet Functions | |||
Referencing Cells | Excel Worksheet Functions | |||
Referencing other cells | Excel Discussion (Misc queries) | |||
Referencing cells | New Users to Excel | |||
Referencing Cells | Excel Worksheet Functions |