Frequent Changes in Price

[rehman4me]

Hello
I want if there is a change in price it should reflect in new records only but should not disturb the previous records with old prices.


a link of my file in the drop box is given below.

https://www.dropbox.com/s/uq3fyn1snj1ah5y/salarzai petroleum.xlsm?dl=0
Password for opening/ editing : nanser
password for unlocking any sheet : 123
Sheet : STOCK
Portion : Sales/ Purchases

 

[rehman4me]

Drop box address is given below
https://www.dropbox.com/s/vpybzn70efogvln/salarzai petroleum.xlsm?dl=0

 

[Pumperkin]

I would approach this by having a sheet with dates and prices, then on your main sheet, a date from which that price should no longer apply. You can then use an IF(Date1<Date2, then PriceA1, if not PriceA2) type formula. You may need multiple ifs if there are frequent price changes. Hope this makes sense

 

[rehman4me]

Thanks Pumperkin