need formula for excel to take percentage off number

what is the formula for excel spreadsheet to take a percentage off a price
column 1 has prices, I want column 2 to take 40% off that price

If A1 contains the price, then in B1 enter:


for example  if A1 shows:


then B1 will show:


86 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated June 30, 2020 Views 66,423 Applies to: