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
Thanks!

Answer
Answer
If A1 contains the price, then in B1 enter:

=A1*(1-.4)

for example  if A1 shows:

100

then B1 will show:

60
GSNU201507

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: