I am creating a worksheet to be filled out by a client. I am trying to get
the cell to update cost typed by 40%. For example when the client types $500
(or whatever number) in the cell it needs to automatically update the amount
by 40%. Any suggestions?