| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to Cells | Excel Discussion (Misc queries) | |||
| retaining formats when referring to cells | Excel Discussion (Misc queries) | |||
| Sort a list with cells referring to others cells | Excel Discussion (Misc queries) | |||
| Referring to Cells in a forumula using a function | Excel Worksheet Functions | |||
| referring to other cells with formulas | Excel Worksheet Functions | |||
Linear Mode
