View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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