How do I create in Excel a cell that will automatically add 20% to any amount input into it without requiring a separate source cell for it to refer to? In other words how do I create a cell that if I input $100 it will automatically display the amount $120?
