Retaining the result of an IF function

**Jaison1** · 03-07-2008, 04:20 PM

I would be grateful for some help please.

I use an IF function to write a "1" in the cell:

=IF($C$15>$A20,IF($C$15<$A22,1,0),0)

I wish to retain the "1" in the cell once the condition has reverted. I don't want it to go back to "0".

Everything I have tried ends up as a circular reference.

**VBA Noob** · 03-07-2008, 04:52 PM

Your formula could be changed to

=IF(AND($C$15>$A20,$C$15<$A22),1,0)

Re your problem. Maybe a small event macro would help. Note it assumes you change C15, A20 and A22 and they are not formulas.

Right click sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

if the cells are formulas try

Please Login or Register  to view this content.

VBA Noob

**Jaison1** · 03-08-2008, 08:22 PM

Thank you for your help.

So far I haven't managed to get any of the above working. I will spend some more time on it and report back later.

Jaison

**VBA Noob** · 03-09-2008, 04:56 PM

Try

Please Login or Register  to view this content.

VBA Noob

**Jaison1** · 03-09-2008, 05:46 PM

Thank you, I am very grateful. This will really get me started.

Now I have the foundations I should be able to progress further before needing any more help.

Jaison

Retaining the result of an IF function

LinkBack

Thread Tools

Rate This Thread

Display

Retaining the result of an IF function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions