Run formula only if values are enter, otherwise leave blank

K

Karen

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
 
P

paul

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

Pete_UK

Hi Karen,

If you are getting a #VALUE error, this implies that A1 contains a text
value - it might look like a number, but it may have an apostrophe in
front of it or the cell may be pre-formatted as Text. Or it might look
blank but contain a space. Something like this should work:

=IF(OR(A1="",A1=" "),"",VALUE(A1)+27)

Hope this helps.

Pete
 
Top