Calculations in Excel
On Sat, 19 Mar 2005 07:51:08 -0800, "Luada"
wrote:
I am designing an invoice sheet and need to have formulas that calculate what
is due. My first problem is how to populate the balance column with the
formula without the #Value showing until I actually have numbers that will
populate that row. I tried the template for invoice but I need to modify it
and then it does not work.
Second, is how to you refer to the last populated balance row in a receipt.
I cannot use the sum as then it adds all the balances. I just need the last
balance row that has a number in it.
Two methods:
1. Use an IF statement to put something else there, like a null string:
=IF(ISERROR(cell_ref),"",your_formula)
2. Use conditional formatting to test for the error, and, if present, make the
font color = background color (default would be white).
--ron
|