| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I =if(any one of 20 specified cell=1," ",1)
Excel formula help please. I want to check 20 cells within a spreadsheet for
a specific value. If at least one of the cells is equal to the specified value return blank if none of the cells is equal to the specified value return the specified value. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I =if(any one of 20 specified cell=1," ",1)
Try this:
=IF(COUNTIF(A1:A20,1),"",0) Is that what you're looking for? *********** Regards, Ron "gwbeck" wrote: Excel formula help please. I want to check 20 cells within a spreadsheet for a specific value. If at least one of the cells is equal to the specified value return blank if none of the cells is equal to the specified value return the specified value. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I =if(any one of 20 specified cell=1," ",1)
Can I expand on Ron's answer?
If your data is in A1:A20 and B1 contains the "specified value" then =IF(COUNTIF(A1:A20,B2),"",B2) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "gwbeck" wrote in message ... Excel formula help please. I want to check 20 cells within a spreadsheet for a specific value. If at least one of the cells is equal to the specified value return blank if none of the cells is equal to the specified value return the specified value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
