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]

yes

Maybe try formating the cells as dates? Or trimming the cells comes too mind as well. Other than that I'd have too see a sample of what you're data.

 

[emcadams7]

I tried that. I have a sample workbook. How would I attach it here?

 

[IanB76]

I am trying to run a similar formula, the formula below works and returns the correct value. However come the end of the month those fields in the table below the formula will become false. What i am trying to do is leave the data in from the last day of each month as we move in to the next one.

The chart is set to plot a graph throughout the course of the year.

=IF(C3=MONTH(TODAY()), $C$16)


[TABLE="width: 774"]
<colgroup><col><col span="10"><col></colgroup><tbody>[TR]
[TD]September[/TD]
[TD]October[/TD]
[TD]November[/TD]
[TD]December[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]May[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]


I have a feeling this is going to be a VBA thing though, and that is defiantly going out of my scope.


Any help is much appreciated.