Formula to result to $0 if no value entered

  • Thread starter Thread starter John Abernathy
  • Start date Start date
J

John Abernathy

I have a spreadsheet that contains a cell that is the sum
of two other values from two other cells. For example, in
cell A1, I have $100.00. In cell A2, I have 7.25%. In
cell A3 is A1*A2. I need a formula that, if there is no
value for cell A2, that A3 will return $0 instead of
#DIV/0 so that I can sum Cell A3 with the same formula
I'm using for cells A6, A7, A8.
 
You won't get that error with a multiplication. However if your formula
looked like

=A1/A2

then you could use

=IF(A2=0,0,A1/A2)
 
-----Original Message-----
I have a spreadsheet that contains a cell that is the sum
of two other values from two other cells. For example, in
cell A1, I have $100.00. In cell A2, I have 7.25%. In
cell A3 is A1*A2. I need a formula that, if there is no
value for cell A2, that A3 will return $0 instead of
#DIV/0 so that I can sum Cell A3 with the same formula
I'm using for cells A6, A7, A8.
.
Click to expand...

Use:
=IF(A2=0,"0",A1*A2)
-the cell will then read out "0" instead of #DIV/0
Shelly
 
Back
Top