If statement that returns data in a cell if False.
 

I have an If statement that reads '=IF(B2="Y","","=B1").
This function is repeated many times, referencing a different cell each time
in the spreadsheet.
At the moment the text '=B1' (or equivalent) is entered into the cell if the
function returns False.
How do I alter the If statement so that the information in cell B1 (not the
reference point) is inserted each time the function returns False.
--
Thank you,

Colin.

If statement that returns data in a cell if False.
 

The reason why you are getting =B1 is that you have enclosed that in quotes,
so that is the text string you've asked for. If you want the value from B1,
then your formula should be =IF(B2="Y","",B1).
--
David Biddulph

"Colin" wrote in message
...
I have an If statement that reads '=IF(B2="Y","","=B1").
This function is repeated many times, referencing a different cell each
time
in the spreadsheet.
At the moment the text '=B1' (or equivalent) is entered into the cell if
the
function returns False.
How do I alter the If statement so that the information in cell B1 (not
the
reference point) is inserted each time the function returns False.
--
Thank you,

Colin.

If statement that returns data in a cell if False.
 

I had tried without the quotes, however I had left in the equal sign.
Thank you for your swift reply.
--

Colin.


"David Biddulph" wrote:

The reason why you are getting =B1 is that you have enclosed that in quotes,
so that is the text string you've asked for. If you want the value from B1,
then your formula should be =IF(B2="Y","",B1).
--
David Biddulph

"Colin" wrote in message
...
I have an If statement that reads '=IF(B2="Y","","=B1").
This function is repeated many times, referencing a different cell each
time
in the spreadsheet.
At the moment the text '=B1' (or equivalent) is entered into the cell if
the
function returns False.
How do I alter the If statement so that the information in cell B1 (not
the
reference point) is inserted each time the function returns False.
--
Thank you,

Colin.