How to Update Prices in Excel by %
Solved/Closed
Related:
- How to Update Prices in Excel by %
- How to update emojis - Guide
- How to take screenshot in excel - Guide
- How do i update my facebook account to new version and design - Guide
- Number to words in excel - Guide
- Ps3 update - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 19, 2009 at 09:20 PM
Dec 19, 2009 at 09:20 PM
suppose your data (sample) is like this from A1 to A5
1
2
3
4
5
in B1(or any other empty cell in the same row) copy this formula
=A1+A1*30%
now copy B1 down
easy way of copying this is select B1 and take the cursor to bottom right of the cell where cursor turns into +
click this + then automatically B1 will be copied down provided there is no gap in the data.
1
2
3
4
5
in B1(or any other empty cell in the same row) copy this formula
=A1+A1*30%
now copy B1 down
easy way of copying this is select B1 and take the cursor to bottom right of the cell where cursor turns into +
click this + then automatically B1 will be copied down provided there is no gap in the data.
Dec 20, 2009 at 03:06 AM