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
GSNU2020

90 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 25, 2021 Views 67,671 Applies to: