I have a sheet which calculates charges due on an account.
I have a box at B10 which can be completed to offer a discount.
I have a dropdown which references to box D5 where a user can select a 'Loyalty Discount' (shows "1" for no discount, then either "2"or "3" for the level of discount...