and/if statement

[Pat]

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.

 

[T. Valko]

Try it like this:

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

 

[Glenn]

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)

 

[Glenn]

In general:

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

Actually, I missed a "("...


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

 

[Pat]

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")

 

[Pat]

Sorry . . . I just got it to work with:
=IF(AND((E5-D5)*24>6,$AO5="Y"),1,0)

THANK YOU BOTH so much!!

 

[T. Valko]

Try it like this:

=--AND((E5-D5)*24>6,$AO5="Y")

Enter the formula *exactly* as shown. Don't add or remove any ( ).

 

[T. Valko]

See my other reply for a better solution.

 

[David Biddulph]

You need to learn to count parentheses, opening and closing.
Look at (E5-D5)*24)>6