You could use Brad's formula to make it look like the cell was empty
(I'd use "" instead of " " though.)
But if you have a formula, then the cell can't be empty.
But if you're doing something with that cell later, you could always look to see
how it evaluated:
=if(c2="",returnonething,returnanother)
or if you use Brad's:
=if(trim(c2)="","",returnonething,returnanother)
Graham wrote:
Thank you very much Brad that works fine.
Just one thing, is there any way of making C2 have a null value until a part number is entered?
--
Dave Peterson