If statement that outputs specific text if cell is not null

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
 
F

Fred Smith

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

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

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with If statement 3
IF function 5
making sure a cell in an array is not duplicated 2
how do I test for a text value in cell c1, if it is there, make c. 1
IF a cell contains specific text 5
Excel If a Cell Contains a Certain Text (From Another Table) 0
Sumif on values in multiple columns 4
Profit only if B2=33 and C2=18, please help 1

Top