Good day to everyone.
Please bear with me.
I have 2 sheets. First sheet, I use for putting down all items and prices of my supplier. This is how it looks.
COL-A COL-B COL-C COL-D COL-E COL-F
COL-A : Item Description
COL-B : Item Size
COL-C : Item Weight
All of the above remains constant.
COL-D : Supplier Price
COL-E : Supplier Price
COL-F : Supplier Price
Columns D to F are prices of 3 models of items.
Now, in sheet no. 2, I have the exact same layout. I wanted to make it so that the prices in sheet no. 2 will change automatically when I change the price in sheet no. 1.
The formula looks something like this:
sheet no. 1 price + 15 + 5%, round off to the next higher integer. If background color of price in sheet no. 1 is grey (any background color other than the default white), the formula is:
sheet no. 1 price + 25 + 5%, round off to the next higher integer.
Hope this is clear enough.
Thanks a lot.
Please bear with me.
I have 2 sheets. First sheet, I use for putting down all items and prices of my supplier. This is how it looks.
COL-A COL-B COL-C COL-D COL-E COL-F
COL-A : Item Description
COL-B : Item Size
COL-C : Item Weight
All of the above remains constant.
COL-D : Supplier Price
COL-E : Supplier Price
COL-F : Supplier Price
Columns D to F are prices of 3 models of items.
Now, in sheet no. 2, I have the exact same layout. I wanted to make it so that the prices in sheet no. 2 will change automatically when I change the price in sheet no. 1.
The formula looks something like this:
sheet no. 1 price + 15 + 5%, round off to the next higher integer. If background color of price in sheet no. 1 is grey (any background color other than the default white), the formula is:
sheet no. 1 price + 25 + 5%, round off to the next higher integer.
Hope this is clear enough.
Thanks a lot.