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