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

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

ExcelBob

[Toppers]

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

[ExcelBob]

Brilliant!!

Thanks Toppers - you're a diamond.

[David Biddulph]

"ExcelBob" <[email protected]> wrote in
message news:[email protected]...
>
> 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"))
--
David Biddulph

[Toppers]

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