=if(a1="","",a1+27).I hope A1 doent have a formula in it,otherwise you might
need
=if(a1=0,"",a1+27)
--
paul

remove nospam for email addy!



"Karen" wrote:

I'm trying to run a simple formula but I only want it to run if the cells
have data in them otherwise I want it to be left blank. I keep getting a
VALUE in the cell where the function is.

Example:

in cell C1 I want to =SUM(A1+27) only if A1 has a value in it otherwise
leave C1 blank

Thanks,
Karen