If I have one cell with
£10 rather than then have multiple cells to get 20% then another to get 20% of that outcome is there an easier way please.
So should be
Cell A1 £10
Cell B1 £14.40
Thanks
If I have one cell with
£10 rather than then have multiple cells to get 20% then another to get 20% of that outcome is there an easier way please.
So should be
Cell A1 £10
Cell B1 £14.40
Thanks
=a1*(100%+20%)*(100%+20%)
=a1*(1.2)*(1.2)
=a1*1.2^2
Or, if the 2 20%'s will not change...
=A1*1.44
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks