If statement that outputs specific text if cell is not null

  • Thread starter Thread starter mcmilja
  • Start date Start date
M

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
 
Just check for null in B2. In C2, put:

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

Regards,
Fred.
 
Back
Top