How to remove #value! as the default

J

JPSabourin

I have entered a formula in a cell which requires another cell to have
a value of 1. This is a spredsheet in which a person would enter the
value of 1 in a cell selected and the dollar amounts in that rage
would enter in another cell for accounting purposes. The would have
three types of payments. But only one is to be checked off. The
Problem I am having, is when there is no value or a 0 as the 1 is
calculated with another cell i get #value! as the error. I would like
the cell to have a value of zero so as to not calculate the dollar
value in that row.

example
row 1 if i enter the value of 1 the payment is 50.00 ( this value has
a formula in that cell to get it's value on another spred sheet, as
their are criterias for the value to enterd).
row 2 if I enter the value of 1 the payment is 40.00
row 3 if I enter the value of 1 the payment is 30.00
=sum(b1:b3)

In order for the correct amount to appear on the accounting sheet, I
only want one total to appear, and not the others as that column is
summed up

If I enter 1 in row one I get $50.00
If I enter 0 in row two I get #value!

How do I get cell b3 to just equal 0 unless a value is entered in a3
but not loose the formulas in b3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top