IF

[Sue C]

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

 

[Mike H]

Sue,

This goes in A37

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

Mike

 

[Sue C]

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]

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

 

[Pecoflyer]

Genius! Thanks Mike.

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

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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[Sue C]

Double Genius! Thanks so much. 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