Excel - can one value be automatically substituted for another?
I want to be able to enter a price in one cell and have the discounted price
appear in the next cell (as if by magic) - the discount varies so can't be
expressed as a percentage or formula. Presumably I'd have to set up a
referral table somewhere that would import the data - but where, ond how...
and when!
|