Posted to microsoft.public.excel.misc
|
|
Hide a formula result until cell has been filled
That did it! Thanks!
"Gord Dibben" wrote:
=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
|