Decrease figures by 40% in excel

Hi, Please help.

I am going crazy. I have done this so many times in the past but today have gone blank!

I have a column of retail prices that i have been given. Example below: I have entered by formula to calculate my percentage and the first one is right ie B1. Now when i try filter that formula down only copies the answer of B1 downwards and does not give correct figures. Im sure i need a doller synbol in here somewhere but cant seem to work it out today. Please help.

The formula that works for B1 is =A1*(1-0.4)

Column A    Column B
69.95
84.95
84.95
74.95
89.95
89.95
44.95
42.12

So basically what i need is less 40% on all my column. We use excel 2013 on a windows 7 machine.

Thank you in advance
solodeedAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

What is you result in B2?

and what are you looking for?

Maybe set calculation Options to Automatic

Regards
Rgonzo1971Commented:
Hi,

Press F9

Regards

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
solodeedAuthor Commented:
Wow as simple as that.

What does this F9 do exactly? Seems ok now

Thanks
Rgonzo1971Commented:
On Formulas / Calculation / Calculation Options

Probably on Manual

F9 is Calculate Now

Regards
solodeedAuthor Commented:
Ok great response. Cant beileve it was that quick to change the answers.

Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.