If statement that returns data in a cell if False.

G

Guest

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.
 
D

David Biddulph

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).
 
G

Guest

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

Colin.


David Biddulph said:
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).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if statement true=now false retains last true 3
IF STATEMENT PROBLEM 4
vlookup multiple data 11
if then statement to return text from cells satisfying condition 2
evaluate a concatenate expression 3
To leave a cell blank following an "IF" function 9
OLD PROBLEM without SOLUTION , part || 1
COUNTIF greater than one column and less than another 5

Top