Formula Help
 

I need help setting up the following cell formulas. Can anyone help with this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

Formula Help
 

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2=" Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)
--
David Biddulph

"aea2517" wrote in message
...
I need help setting up the following cell formulas. Can anyone help with
this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

Formula Help
 

Hi

I don't understand what you want to do.
Do you want to change the N to Y if the value change to 0 or .....
Where can these numbers be found, in the same sheet or others and
which cells are they in?

HTH

Pls click the Yes button if this help

cheers, francis

aea2517 wrote:
I need help setting up the following cell formulas. Can anyone help with this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

Formula Help
 

Dear David,
Thanks so much, it's perfect.
Ann

"David Biddulph" wrote:

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2=" Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)
--
David Biddulph

"aea2517" wrote in message
...
I need help setting up the following cell formulas. Can anyone help with
this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

Formula Help
 

Thank you so much for your quick response that was extremely helpful. Would
I be able to use this formula to calculate a full year instead of just 3
months?

"David Biddulph" wrote:

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2=" Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)
--
David Biddulph

"aea2517" wrote in message
...
I need help setting up the following cell formulas. Can anyone help with
this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0

Formula Help
 

see your other post

--
Biff
Microsoft Excel MVP


"aea2517" wrote in message
...
Thank you so much for your quick response that was extremely helpful.
Would
I be able to use this formula to calculate a full year instead of just 3
months?

"David Biddulph" wrote:

=10*COUNTIF(A2:C2,"Y")+AND(A2="Y",B2="Y")+AND(B2=" Y",C2="Y")+(COUNTIF(A2:C2,"Y")=3)
--
David Biddulph

"aea2517" wrote in message
...
I need help setting up the following cell formulas. Can anyone help with
this?
You'll notice Y changes value depending on it's juxtaposition to N.
Oct Nov Dec
Y Y Y 33 =10+11+12
Y Y N 21 =10+11+0
N Y Y 21 =0+10+11
Y N Y 20 =10+0+10
Y N N 10 =10+0+0
N Y N 10 =0+10+0
N N Y 10 =0+0+10
N N N 0 =0+0+0