retaining a value
Posted by Ken Ledford on January 09, 2002 10:11 AM
I'm new to excel and hope this doesn't sound crazy. I need to retain the value of an if statement after the statement goes false.small example.Set the cell h1 to 1
the formula in my cell might read =if(h1=1,255).In my formula cell I'll get my 255.I need to retain the value when h1 next might be 2 and will have another value assigned to it.I just need a way to retain these values dumped off to another cell where they become hard values.I'm not even sure this is possible but thought i'd ask.
Thanks for any help