calculate 150% of a value

J

Jason Reynolds

Hi all.. im a bit of a newbie .. can anyone help me with this?

Im making a spreadsheet that has a dollar amount in the second column.
The third column has to calculate 150 % of the the value from the
second column.

I have to calculate this for each row in the column. How can I do
this? Can someone point me in the right direction?

Thanks!
 
D

Dave Peterson

Type this in C1:
=B1*1.5

And using the little box on the bottom right corner of that cell outliner, drag
down the column.

You could double click on that "autofill" button and it'll go until it finds a
gap in the adjacent column.

Another formula that will evaluate the same:
=b1*150%

Use the one you find easier to understand.
 
J

Jason Reynolds

Thank you so much it did the trick!

Type this in C1:
=B1*1.5

And using the little box on the bottom right corner of that cell outliner, drag
down the column.

You could double click on that "autofill" button and it'll go until it finds a
gap in the adjacent column.

Another formula that will evaluate the same:
=b1*150%

Use the one you find easier to understand.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top