Previous Topic Next Topic

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

Closed
ChrissyCobra Posts 1 Registration date Thursday January 8, 2015 Status Member Last seen January 8, 2015 - Jan 8, 2015 at 11:43 AM
 Blocked Profile - Jan 8, 2015 at 01:36 PM
Hello,

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 response

Answer 1 / 1
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!"
1

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses