IF FALSE

[toc63]

THANKS FOR TAKING THE TIME TO READ MY LETTER.

NOW RIGHT TO THE QUESTION.

WHEN USING AN "IF" FUNCTION.

WHAT I WOULD LIKE TO DO IS GET THE VALUE OF A CELL WHEN TRUE, AND KEEP THE THE LAST VALUE OF THE CELL WHEN IT GOES FALSE.

THE TRUE PART IS EASY, BUT I CAN'T GET THE FALSE PART.

EXAMPLE:

CELL A2 HAS EITHER A VALUE OF 1 OR 0 IN IT DEPENDING ON OTHER ARGUMENTS
CELL A3 IS A VARIABLE BETWEEN 1 AND 120 AND CHANGES DEPENDING ON OTHER ARGUMENTS

CELL A1 IS MY "IF" FUNCTION
IF A2=1
IF TRUE A1=A3 A1 CHANGING AS A3 CHANGES

NOW HERES WHAT I WOULD LIKE
IF FALSE A1=WHAT A3 EQUALED JUST BEFORE A1 WENT FALSE, AND HOLDING THAT VALUE UNTIL A1 GOES TRUE AGAIN

CAN YOU HELP ME????

THANKS

Thomas O'Connor
39 Fairchild dr.
Amherst N.Y. 14226
toc63@earthlink.net

 

[toc63]

Jay and Adam

Thank you both very much. You guys are terrific. It works great.

Tom