Looking at one cell if contains number returning text...

Registration date
Thursday January 8, 2015
Last seen
January 8, 2015
- Jan 8, 2015 at 11:43 AM
 Blocked Profile - Jan 8, 2015 at 01:36 PM

I am trying to figure out a way to streamline a huge excel spreadsheet we have at work.

I am trying to return text in a cell if there is a '1' in a seperate cell...

Trying to put it in Excel talk - 'If B1 has a '1' in it then return the text in C1 in cell A1'

I hope this makes sense, I have tried looking at the 'IF' formula but cannot seem to get anywhere, any advise appreciated. Thanks.

1 reply

Blocked Profile
Jan 8, 2015 at 01:36 PM
OK, welcome to the forum!

This is the standard IF(logic_check,true,false).

Try this:

in cell A1 enter the following: =IF(B1=1,C1,"")

Give that a try!

"If you would have told me 20 years ago that everyone was going to be a photographer in 20 years, I wouldn't have believed you!"