How to show value in row A in column A if column B row A value is TRUE

If column B row A value is "7" and column A row a is John, I'd like the result to show "John 7" in a another cell.
dorianitAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
I'm not entirely sure this is what you want, but perhaps

=IF(B1=7, A1&" "&B1)

and copy down as needed.
0
 
dorianitAuthor Commented:
Rorya,
Thanks, I'll give that a try.

I made a change..what if I want to check if the number is greater than 0 and THEN A1&" "&B1 as you had suggested?

Thank you.
0
 
Marc ZConnect With a Mentor Commented:
=IF(B1>0, A1&" "&B1)
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
Is this what you want?

=IF(B1>0, A1&" "&B1)

I ask because when the value in column B is zero, the "another cell" value becomes "FALSE". If you'd rather it be blank then do this instead

=IF(B1>0,A1&" "&B1,"")

And of course in either case copy down as needed,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.