This must be so simple but I have struggled with this sort of thing for so long now and would appreciate any help you can give me.
What I am trying to do is, times a field by a percentage and the add them together { Sum(A1*B1)+A1 } and then times the result by another cell, which is another percentage, and then add that to the sum of the first to get a total in a single cell. If I was writing it I would write it something like this;
A1 B1 B1 B2 A2 (end total)
£0.061 x 6.6% + £0.061 = £0.065 x 2% + £0.065 = £0.066
Really appreciate any help you can give me as I'm sure you should be able to do this in a single cell and not have to do this over 2 or 3.
Thanks
What I am trying to do is, times a field by a percentage and the add them together { Sum(A1*B1)+A1 } and then times the result by another cell, which is another percentage, and then add that to the sum of the first to get a total in a single cell. If I was writing it I would write it something like this;
A1 B1 B1 B2 A2 (end total)
£0.061 x 6.6% + £0.061 = £0.065 x 2% + £0.065 = £0.066
Really appreciate any help you can give me as I'm sure you should be able to do this in a single cell and not have to do this over 2 or 3.
Thanks