Hi,

How is A1 populated with this value you want to retain? If it's from another
cell then reference that cell or if it's a fixed vlue then use that fixed
value in the formula.

=IF(B5=1,10,100)

Mike

"shoy" wrote:

Does anyone know how to make an IF function take no action if the logic test
is false?. I want to change the value in a cell if the logic test is true,
but leave the current value alone if false.

It seems like MS forces the cell to be zero or blank or whatever the third
part of the argument is set at if the logic test is false

I remember using =IF(B5=1,10,A1) in cell A1 in an older spreadsheet
program, which set cell A1 to 10 if B5 was 1, but otherwise left the cell's
current value alone. It definitely worked. However MS finds the reference to
A1 within cell A1 a circular reference.

thanks
--
shoy