=IF(C6="","",C6)

=IF(C6="","",C6+30)

What the formula does is return a blank-looking cell if C6 has no data,
otherwise return the calculated value.


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 11:29:01 -0700, Higgy
wrote:

I am working with a spreadsheet and would like to do the same. How would this
work for the formula =C6 or Formula =C6+30
Thanks
"Sammy" wrote:

Much appreciated :D

"via135" wrote:


hi!

=IF(C3="","",40-C3-0.2)

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=543995