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