Formula to incude multiple requirments in different cells

[Aquabenny]

Hi,

I would like a cell to show either OK or No depending on the requirements of three other cells as below

G4 is the cell to show a value. For OK a date in G6 must be more than todays date, a tick must be in F6 and a date in D6 must also be more than todays date.

I can get G4 to do each section individually i.e. (A4 has todays date in it, updating automaticaly)

=IF((G6+365)<a4,"ok","no")
=IF(F6="P","Ok","No")
=IF((D6+365)<a4,"ok","no")

How do if put them together?

Thank you for any help you can offer.</a4,"ok","no")
</a4,"ok","no")

 

[Aquabenny]

Sorry looks like to formulas have lost a bit. Here they are again

=IF((G6+365)<A4,"Ok","No"
=IF(F6="P","Ok","No")
=IF((D6+356)<A4,"Ok","No")

 

[Aquabenny]

Sorry looks like to formulas have lost a bit. Here they are again

=IF((G6+365)<a4,"ok","no"
=IF(F6="P","Ok","No")
=IF((D6+356)<a4,"ok","no")[ QUOTE]


Sorry This is my first post and the text doesn't seem to like to formulas! It keeps taking sections out.</a4,"ok","no")[></a4,"ok","no"