Product price sheet

northfield

New member
Joined
Oct 16, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2007
I have a price sheet with over 100 items.
I would like to be able to change the percentage in A7 that would make the change in corresponding product such as f7
also make the change in B7 that would make the change in the other corresponding cells.
Is this possible
Dave
 

Attachments

  • Price list test.xlsx
    14.2 KB · Views: 16
In A7, change to .36
In F7 change to =A7
In each cell that now has Exchange 36%, change to =A7
In each B7 change to =(B5+B6)*1+A7. Make similar changes in the other cells that you wish to have pricing generated by the value in the percentage cell.
 
Back
Top