[mcmilja]

Hello,

Is there an If statement that will output specific text if a cell is not
null? For example: if cell B2 contains data, then C2 outputs text "In-Use".

(Router Interface Name) Status
B2: BTS8-R1-MLG1-URC1-T1-1 C2: In-Use
B3: #N/A C3:
B4: BTS8-R1-MLG1-URC1-T1-2 C4: In-Use

Thanks,
Jaret

[Tim879]

Try this....

=if(isblank(b2),"","In Use")

On Jun 4, 9:01 am, mcmilja wrote:
Hello,

Is there an If statement that will output specific text if a cell is not
null? For example: if cell B2 contains data, then C2 outputs text "In-Use".

(Router Interface Name) Status
B2: BTS8-R1-MLG1-URC1-T1-1 C2: In-Use
B3: #N/A C3:
B4: BTS8-R1-MLG1-URC1-T1-2 C4: In-Use

Thanks,
Jaret

[Fred Smith[_4_]]

Just check for null in B2. In C2, put:

=if(b2<"","In-Use","B2 is null")

Regards,
Fred.

"mcmilja" wrote in message
...
Hello,

Is there an If statement that will output specific text if a cell is not
null? For example: if cell B2 contains data, then C2 outputs text
"In-Use".

(Router Interface Name) Status
B2: BTS8-R1-MLG1-URC1-T1-1 C2: In-Use
B3: #N/A C3:
B4: BTS8-R1-MLG1-URC1-T1-2 C4: In-Use

Thanks,
Jaret