Hi Dan,
Fairly simple: Bracket your formulae with 'if' statements based on the
content, or lack thereof, in the input cells. If A1 is one of the input
cells, then the formulae that use the data from that cell, or any cell
that depends on A1 should look like this:
=if(a1<>"";---your formula---;"")
This will give you a blank result if A1 is blank or the original
calculation if A1 contains some data. If you want to be real slick, you
could test A1 to ensure that the data is valid.
=if(a1<>"";if(isnumber(A1);your formula;"Invalid entry - A1");"")
tc
Dan Cox wrote:
Here's one that I am sure will get plenty of replies:
I am setting up a spread sheet to calculate payments, balance owed, etc, and I
have 25 rows that can have data input (just to keep it all on one sheet). How
do I keep the calculating formula, but make the cells stay blank (not show
$0.00) if I do not put name or some other identifier into that row. In other
words, how do I get only the rows that need to have calculated to show
calculations, and have the remainder stay blank, but still ready to accept
data. I do not want to hide the rows, because I am not the one who will use
this spreadsheet, and that has already caused me messes in the past. Thank you
in advance for the replies.
Dan
Sincerely,
Dan Cox, CEO
Tech To Go, LLC
(843)729-6443
[EMAIL PROTECTED]
www.1TechToGo.com
---------------------------------
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
