Formula Syntax Assistance Required

Hi,

Can anyone please advise me of the syntax required to amend the following formula:-

Please Login or Register  to view this content.

=IF(I7>G7,"Fail","Met")

Please Login or Register  to view this content.

The formula works to a degree, but when I copy the formula down the column it still displays ‘Met’ even when there is not data in the corresponding cells in columns ‘A’ and ‘C’

N.B. I’ve also added so conditional formatting to highlight green for a ‘Met’ and red for a ‘Fail’

Ideally, if there is no data for in columns ‘A’ and/or ‘C’ the cell in column ‘D’ should just be left blank i.e. no text and no colour

Any assistance received would be greatly appreciated

Many thanks in advance


Regards

Rob

Pete_UK & 63falcondude,

sorry I confused myself with regards to my cell references but I glad to say you code work as required

Many thanks


Regards



Rob