2009/9/7 Walter Hildebrandt <[email protected]>: > The following formula works to give a Yes or a No in C1 > > IF(AND(A1>=0;B1>=0);"Yes";"No") > > How can that formula be increased so that not only A1 and B1 is used but > that C1, D1 and E1 be included > > In other words, what formula can be used when A1>=0 and B1>=0, and C1>=0 and > D1>=0 and E1>=0 so that Yes or No appears in F1 >
Isn't it possible to do just add them like IF(AND(A1>=0;B1>=0;C1>=0;D1>=0;E1>=0);"Yes";"No")? I thought so, but maybe I'm wrong. J.R. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
