total the column anyway

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a way to use my formula even when there is no discount.

I
45 Tuition $1596.00
46 Registration Fee $25.00
47 Textbook $75.00
48 Group Discount 5%
49 Total I45-(I45*I48)+I46+I47

Formula works, but what if there's no discount? If cell I48 is blank then I
get #value. I want it to total my numbers even if there is no discount.
Thanks for looking at this.

Rob
 
Robb27 wrote...
I need a way to use my formula even when there is no discount.

I
45 Tuition $1596.00
46 Registration Fee $25.00
47 Textbook $75.00
48 Group Discount 5%
49 Total I45-(I45*I48)+I46+I47

Formula works, but what if there's no discount? If cell I48 is blank then I
get #value. I want it to total my numbers even if there is no discount.
Click to expand...

If I48 were truly blank, it'd be evaluated as if it were zero in your
formula, so your formula wouldn't return #VALUE!. Obviously, it's not
blank even if it may *appear* to be.

Rewrite your I49 formula as

=SUM(I45:I47,-N(I48)*I45)
 
Hi,
That formula still returns a #value. If I change the <> to an = Then it
works. But.
It won't work if I have a discount. ?

Rob
 
Robb...If you need to print this calculation sheet, would you mind to type 0%
in order to complete this sheet....otherwise use the If's.
 
Ok, got it. Stumbled on to it by accident (if there are any...grin)
I took a shot and put an equals sign before the <> and Excel told me it was
going to change the formula to this:
IF(I48<="",I45-(I45*I48)+I46+I47,I45+I46+I47)
and asked me if i wanted to keep it. I said, "sure, why not?" and it works.
Imagine that.
Thank you for giving me a push!
 
Back
Top