Easy Peasy
 

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...

ExcelBob


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=563210

Easy Peasy
 

=IF(C8="","",IF(AND(C8<"",R8=""),"Active",IF(AND( C8<"",R8<""),"Terminated")))

"ExcelBob" wrote:


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...

ExcelBob


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=563210

Easy Peasy
 

Brilliant!!

Thanks Toppers - you're a diamond.


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=563210

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

Easy Peasy
 

David's response is smarter!

"ExcelBob" wrote:


Brilliant!!

Thanks Toppers - you're a diamond.


--
ExcelBob
------------------------------------------------------------------------
ExcelBob's Profile: http://www.excelforum.com/member.php...o&userid=34152
View this thread: http://www.excelforum.com/showthread...hreadid=563210