=IF(OR(C7="",G7=""),"<---REQUIRED FIELD","")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marilyn" wrote in message
...
Hello My formula is =IF(C7<"","","<--- REQUIRED FIELD"). what I want
to
do is add another cell reference to the formula . In plain english if
either cell C7 or cell G7 is blank then "<---REQUIRED FIELD" if both
cells
are not empty then nothing. thanks in advance