Reply
Fri 3 Oct, 2003 12:14 am
If J14 has a value of 74 and L14 has a value of 8
In N14 I get 5% of 74 by formula =sum(J14*5%) result should be 4
In O14 I need the amount over 5% so I use formula =sum(L14-N14) result should be 4
In Q14 I need to multiply the totoal of O14 by $105
The result I get is $451.50 it should be $420 (4*105= 420)??
Here's why it doesn't work:
Quote:In N14 I get 5% of 74 by formula =sum(J14*5%) result should be 4
That doesn't work. 5% of 74 is 3.7, so then 8 - 3.7 is 4.3 and then 4.3 times $105 is $451.50.
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace