Product of an unknown number

Is there a way to write a formula for a cell that takes an unknown number and multiplies it times a given number ( product = X times 1.2 ).

I want to be able just to enter a value and it will automatically do a mark up of 1.2 without referring back to a previous cell, so when it is printed the customers does not see mark up applied.

Thanks
Mike

You could set the print area and have the cell that contains the amount of the markup outside of the print area. To do that you would select the area of the invoice that you want to print and go to file print area, set print area. then you can have the original price and the amount of the markup on a different part of the sheet. you could also accomplish it by having that information in another worksheet.

Hi,

Assuming say E5 is the cell in question, you could put the following line of code in the Worksheet_SelectionChange event

Please Login or Register  to view this content.

HTH