|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 17th, 2009, 04:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formulas
I have a column for every month (12) and I have criteria that must be met all
months in order for annual points to be awarded. How can I tell cell P5 that if all cells from D5 to O5 each have an x in them than P5 should equal 50, but if any one cell does not have the x then P5 should equal 0? Does that make sense? I know how to tell it when I'm only looking at one cell: If(D5="x",20,0), but I need it to look at all cells on that row. I'd appreciate any help. 
|
|
#2
April 17th, 2009, 04:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formulas
if(countif(d5
 5,"x")=12,50,0)-- Don Guillett Microsoft MVP Excel SalesAid Software "Clara" wrote in message ... I have a column for every month (12) and I have criteria that must be met all months in order for annual points to be awarded. How can I tell cell P5 that if all cells from D5 to O5 each have an x in them than P5 should equal 50, but if any one cell does not have the x then P5 should equal 0? Does that make sense? I know how to tell it when I'm only looking at one cell: If(D5="x",20,0), but I need it to look at all cells on that row. I'd appreciate any help.
|
|
#3
April 17th, 2009, 04:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formulas
=(COUNTIF(D5:O5,"x")=12)*50
"Clara" wrote: I have a column for every month (12) and I have criteria that must be met all months in order for annual points to be awarded. How can I tell cell P5 that if all cells from D5 to O5 each have an x in them than P5 should equal 50, but if any one cell does not have the x then P5 should equal 0? Does that make sense? I know how to tell it when I'm only looking at one cell: If(D5="x",20,0), but I need it to look at all cells on that row. I'd appreciate any help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
