Results 1 to 2 of 2

Thread: Product price sheet

  1. #1
    Neophyte northfield's Avatar
    Join Date
    Oct 2018
    Posts
    1
    Articles
    0
    Excel Version
    2007

    Product price sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    194
    Articles
    0
    Excel Version
    2019
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •