If statement that outputs specific text if cell is not null

[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")

 

[Fred Smith]

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

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

Regards,
Fred.