Autosum discount formula according the cells different from 0.00

[momchil.vladov]

Hallo again,
I wonder if there is such a formula that:

You take 5 cells to autosum in 6th cell. If more than one cell from those 5 cells is different from 0.00 to automatically make 10% discount.
Is there such a formula?

Thank You very much

[Glenn Kennedy]

Assuming your data are in A1:a5, try this:

Please Login or Register  to view this content.

[momchil.vladov]

It says that the formula has an error. I've made the following;

A11+B11=A1
A12+B12=A2
A13+B13=A3
A14+B14=A4
A15+A15=A5

I try to put formula in D8 for example. It says that it has an error.

[Glenn Kennedy]

Ummmm. No it doesn't. Please post your sheet, if this doesn't solve your problem

[momchil.vladov]

Don't know why but now it doesn't say there is an error.
This way could do the trick, but the idea was different.
For example:
A1=100
A2=0
A3=0
A4=0
A5=0
D8=100
If only one of the "A" cells is different from "0" to sum them without making discount.

If it is this way:
A1=100
A2=50
A3=0
A4=70
A5=30
D8=225 ((100+50+0+70+30)-10%)
If there are more than one cells bigger then "0" D8 to show the total amount with 10% discount.

If there is no such a formula your way can to the trick. Thank you very much for it.

[oeldere]

I read the question like this.

I used Glenn Kennedy 's formula for that.

Please Login or Register  to view this content.