View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default IF statement problem

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

Mike F

"Jim Robinson" wrote in message
...
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.