I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue

Genius! Thanks Mike.

PS. Is there anyway that the copied contents of Cell R5 (ie. once they are
in cell A37) can be preceded by a couple of words of text, which will always
be the same? Thanks again.

"Mike H" wrote:

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue

Sue,

Because you have something in B37 then A37 will need to be wide enough to
accomodate the text but you can do it like this

=IF(B37<"","Thanks for the feedback " &R5,"")

Or have the text in a cell and reference it

=IF(B37<"",A38&R5,"")

If you do it the second way then add a space to the end of the text as I did
with the text in the first example.

Mike

"Sue C" wrote:

Genius! Thanks Mike.

PS. Is there anyway that the copied contents of Cell R5 (ie. once they are
in cell A37) can be preceded by a couple of words of text, which will always
be the same? Thanks again.

"Mike H" wrote:

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue

Sue C;258290 Wrote:
Genius! Thanks Mike.

PS. Is there anyway that the copied contents of Cell R5 (ie. once they
are
in cell A37) can be preceded by a couple of words of text, which will
always
be the same? Thanks again.

"Mike H" wrote:

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to
work.

I have a cell in which I want to copy the value (which will be a
number)
from another cell, but only if a third cell has an entry in it
(which will be
text). How do I use the IF syntax to say IF B37 has any value in
it, then
copy R5 into A37? Thanks. Sue

Hi,
try =IF(B37<"","your_text"&R5,"")


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72112

Double Genius! Thanks so much. Sue


"Mike H" wrote:

Sue,

Because you have something in B37 then A37 will need to be wide enough to
accomodate the text but you can do it like this

=IF(B37<"","Thanks for the feedback " &R5,"")

Or have the text in a cell and reference it

=IF(B37<"",A38&R5,"")

If you do it the second way then add a space to the end of the text as I did
with the text in the first example.

Mike

"Sue C" wrote:

Genius! Thanks Mike.

PS. Is there anyway that the copied contents of Cell R5 (ie. once they are
in cell A37) can be preceded by a couple of words of text, which will always
be the same? Thanks again.

"Mike H" wrote:

Sue,

This goes in A37

=IF(B37<"",R5,"")

Mike

"Sue C" wrote:

I think IF is the correct formula to use here, but can't get it to work.

I have a cell in which I want to copy the value (which will be a number)
from another cell, but only if a third cell has an entry in it (which will be
text). How do I use the IF syntax to say IF B37 has any value in it, then
copy R5 into A37? Thanks. Sue