Try it like this:

=IF(AND((E5-D5)*246,$AO5="Y"),............)

--
Biff
Microsoft Excel MVP


"Pat" .(donotspam) wrote in message
...
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.

--
Thanks, Pat