View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Help with If Function

You need to tell us what you're trying to do.

=IF(AND(A319,B317),"1",IF(AND(A329,B3<17),"2",I F(AND(A3<29,B317),"3",IF(AND(A3<29,B3<17),"4"))))

Regards,
Paul

--

"Joy" wrote in message
...
Can someone help me fix this because it doesn't seem to work and I don't
know
where to go from here?

=IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4"))))
--
Thanks, Joy