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

Excel - IF function with multiple words
Nick -
user -

14 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses