To add 20% then another 20% on that figure

**king10001** · 01-07-2019, 04:58 AM

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

**Bo_Ry** · 01-07-2019, 07:20 AM

=a1*(100%+20%)*(100%+20%)
=a1*(1.2)*(1.2)
=a1*1.2^2

**FDibbins** · 01-07-2019, 05:20 PM

Or, if the 2 20%'s will not change...
=A1*1.44

To add 20% then another 20% on that figure

LinkBack

Thread Tools

Rate This Thread

Display

To add 20% then another 20% on that figure

Re: To add 20% then another 20% on that figure

Re: To add 20% then another 20% on that figure

Thread Information

Users Browsing this Thread

Similar Threads

VBA: Show Subtracted Figure In Cell When Cumulative Figure Is Entered

Data figure goes to Report figure base on header

[SOLVED] Using Linear Regression to predict a future event / performance figure / speed figure

[SOLVED] Using Linear Regression to predict a future event / performance figure / speed figure

[SOLVED] How to insert sub-caption for figures? figure 1, figure 2-a, figure 2-b, figure 3, ...

Sum formula to exclude monthly budget figure when actual figure is entered

Calculating monthly sales figure required to make annual turnover figure

Bookmarks

Bookmarks

Posting Permissions