Easy Peasy

[ExcelBob]

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 tex
"Terminated"
or if c8 is blank leave the current cell blank

Hope some brain box can help me....Thanks in adv...

ExcelBo

 

[Guest]

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

 

[ExcelBob]

Brilliant!!

Thanks Toppers - you're a diamond

 

[David Biddulph]

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","Terminated"))

 

[Guest]

David's response is smarter!