Do Not Calculate Cell if Reference Cell in Formula is Empty 1

[akrshaw]

Sorry, I have no idea how else to describe that...grin

I have this cell:

=SUM(Budget!C6)-('Input Numbers'!A6)

What I am looking for is to have nothing show up if the Input Number cell is empty...

I have no idea what direction to go with this one!~

Thanks sooo very much!~

 

[randy700]

How about:

=if('InputNumbers'!A6="","",SUM(Budget!C6)-('Input Numbers'!A6))

Randy

 

[akrshaw]

Randy

Thank you!~

Works perfectly!~