At 08:13 07/09/2009 -0600, Walter Hildebrandt wrote:
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
The AND() function accepts up to thirty arguments, so - as has
already been suggested - you can just add more conditions as required:
=IF(AND(A1>=0;B1>=0;C1>=0;D1>=0;E1>=0);"Yes";"No")
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
