Nested IF AND functions.
=if(and(a1="ok",b1=13,c42="xxy"),"all true","at least one false")
(I stopped before I got to 5 tests.)
Deb wrote:
I have not used Excel functions for a while and apparently can't figure it
out now. I
need to have 5 logical tests to be true in an IF statement. Does anyone know
the correct format with commas and parenthesis in the right place? Thanks, Deb
--
Dave Peterson
|