Leaving a value unchanged (IF statement)

[jenniesc]

Hi!

I have a very simple IF formula but I want the False statement to leave the value in the cell unchanged.

Any one??!

Cheers

 

[John Davis]

Hi!

I have a very simple IF formula but I want the False statement to leave the value in the cell unchanged.

Any one??!

Cheers

I think that would create a Circular Reference problem. I don't think it can be done by formula.

 

[taigovinda]

Not sure exactly what you are asking. Could you provide an example?

This would evaluate to true or else blank, not sure if that's what you mean...


=if(A1="yes",true,"")

 

[jenniesc]

Thanks for your reply.
What I am trying to do is have a results page. I am running a LP model in one sheet and I want the results from the model to be inputted into a results sheet.
I then went to make sure those results remain there when I return to the LP model and run for different results. These results will then be picked up by a separate results table and must remain there when the LP model is run again.

=IF($A$2="Season 2",('Diet'!C21),(""))
Season 2 is the name of the results that will change. But if A2 is not season 2 I want the cell to keep it's contents (be it blank or a number) and not return blank"".

Hope this is clear and there is a way somehow!

Many Thanks

 

[John Davis]

Thanks for your reply.
What I am trying to do is have a results page. I am running a LP model in one sheet and I want the results from the model to be inputted into a results sheet.
I then went to make sure those results remain there when I return to the LP model and run for different results. These results will then be picked up by a separate results table and must remain there when the LP model is run again.

=IF($A$2="Season 2",('Diet'!C21),(""))
Season 2 is the name of the results that will change. But if A2 is not season 2 I want the cell to keep it's contents (be it blank or a number) and not return blank"".

Hope this is clear and there is a way somehow!

Many Thanks

Does this work: =IF($A$2="Season 2",'Diet'!C21,A1)

 

[John Davis]

Thanks for your reply.
What I am trying to do is have a results page. I am running a LP model in one sheet and I want the results from the model to be inputted into a results sheet.
I then went to make sure those results remain there when I return to the LP model and run for different results. These results will then be picked up by a separate results table and must remain there when the LP model is run again.

=IF($A$2="Season 2",('Diet'!C21),(""))
Season 2 is the name of the results that will change. But if A2 is not season 2 I want the cell to keep it's contents (be it blank or a number) and not return blank"".

Hope this is clear and there is a way somehow!

Many Thanks

Does this work: =IF($A$2="Season 2",'Diet'!C21,A2)

 

[jenniesc]

Yes that works!

Thank you.

 

[emcadams7]

Hi,

I tried that on a similar cell but my date (which I want to remain unchanged) goes to 1/00/00. Any suggestions?

Thanks

 

[John Davis]

Hi,

I tried that on a similar cell but my date (which I want to remain unchanged) goes to 1/00/00. Any suggestions?

Thanks

The only way I could duplicate what you have is if the IF Statement is referencing a blank cell. Do you have $ signs as above?

 

[emcadams7]

yes