In A1 I have this: $9.50.
In A2 I want to display the result of multiplying A1 with 10% and subtracting the result from A1.
I've tried this in A2: =SUM(A1*10%)-SUM(A1)
But it displays a negative number: -$8.55
I need it to display: $8.55
In A1 I have this: $9.50.
In A2 I want to display the result of multiplying A1 with 10% and subtracting the result from A1.
I've tried this in A2: =SUM(A1*10%)-SUM(A1)
But it displays a negative number: -$8.55
I need it to display: $8.55
Last edited by David A; 10-07-2008 at 11:36 PM.
OK, I figured it out: =SUM(B98-(B98*10%))
David, couldn't you simplify this to just
=B98*.9
or
=B98*90%
Algebraically, x - .1x == .9x
Yes I could. Didn't think about that.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks