View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_2_] trip_to_tokyo[_2_] is offline
external usenet poster
 
Posts: 70
Default How to increase all values in my spreadsheet by 10% automatically

Errol, there could be a variety of ways of doing this depending upon how you
have constructed your Workbook but here is a simple possible solution:-

1 10% 0.1
2 10% 0.2
3 10% 0.3
4 10% 0.4
5 10% 0.5

The above info was entered into cells A1:C5.

Please hit Yes if my comments have been helpful to you.

Thanks!




"Errol" wrote:

If I have entered in all my values and formulas into a worksheet and I want
to increase all these values by 10%, how do I go about doing this?

Cheers