Easy Peasy
"ExcelBob" wrote in
message ...
But my brain isn't working this morning;
Want to enter a formula for the following;
if c8 contains a value and r8 is blank return the text "Active"
or if c8 contains a value and r8 contains a value return the text
"Terminated"
or if c8 is blank leave the current cell blank
Hope some brain box can help me....Thanks in adv...
=IF(ISBLANK(C8),"",IF(ISBLANK(R8),"Active","Termin ated"))
--
David Biddulph
|