this is what I am trying, however still receiving and error. ;(

=IF(AND(E5-D5)*24)6,($AO5="Y")),1,0)

First test: (E5-D5)*24)6
Second test: ,($AO5="Y")

--
Thanks, Pat


"Glenn" wrote:

Pat wrote:
I'm trying to write an and/if statement - if possible

IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1

but I can't seem to be entering it correctly. Any suggestions please.


In general:

=IF(AND(first_test),(second_test)),both_tests_true ,either_test_false)