I have 2 sheets with various dates and prices on them with regards to stock, what i need to do is link them to a third sheet with this data being the outcome;
Products more than 6 months old - 30% off price
Products more than 9 months old - 60% off price
I also need to make the % variable by the user and am not allowed to use macros.
Could anyone help me with this please ?
Thanks very much
Anx
Products more than 6 months old - 30% off price
Products more than 9 months old - 60% off price
I also need to make the % variable by the user and am not allowed to use macros.
Could anyone help me with this please ?
Thanks very much
Anx