Excel Formula

[BR759173]

I want to test a cell for a text value. If the text value is true I want the next cell below to accept a text value of my choosing, i.e. if a cell contains the word Monday I want to enter into the next cell the word Tuesday.

Can anyone help?

[Ron Kinner]

Sort of. You really need to put the test in the cell below. Ex: Put the following in A2 then put Monday in A1

=IF(A1="Monday","Tuesday","not Tuesday")

If A2 is already a function and you want to feed it a value then you put the above in a dummy column B row 1 and refer the function in A2 to B1.

Ron