IF statement problem

J

Jim Robinson

If the If test is false I want to leave the contents of a cell the same, If it is true I want to change the cell contents. I have no problem withe the true condition but I don't know how to enter the false condition.
 
M

Mike Fogleman

You don't need a False condition if no changes are to be made.
IF test = True Then Cell= "Whatever"

Mike F

Jim Robinson said:
If the If test is false I want to leave the contents of a cell the same,
If it is true I want to change the cell contents. I have no problem withe
the true condition but I don't know how to enter the false condition.
 
Top