ExcelBanter - IF Formula referring to 2 cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula referring to 2 cells (https://www.excelbanter.com/excel-discussion-misc-queries/225145-if-formula-referring-2-cells.html)

Marilyn

IF Formula referring to 2 cells

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

Niek Otten

IF Formula referring to 2 cells

=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

All times are GMT +1. The time now is 02:27 AM.