Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|