View Single Post
  #1   Report Post  
RobBoddy
 
Posts: n/a
Default 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!