How do I add 1.5 to a column in Excel?

How do I add 1.5 to a column in Excel?
by

1 Answer

Answer :

If you have a list of values in one column and want values thatare 1.5 higher in another you could have a formula to add them. Soif you had values in column A, say in cell B2 you could add 1.5 toA2 like this, and copy it to the necessary cells:=A2 + 1.5If you want to increase the value of the original cells, thereis a special way of doing it. Type 1.5 into a cell. Select thecell. Do a copy. Select the cell you want to add 1.5 to. Go toPaste Special. In the Operation section of the dialog box pick Add.1.5 will be added to the cell. If there is a value in the cell, itwill change the value to the new one. If there is a formula in thecell, it will put +1.5 at the end of it.
by

Related questions

How do I add 1.5 to a column in Excel?

Description : How do I add 1.5 to a column in Excel?

Last Answer : If you have a list of values in one column and want values thatare 1.5 higher in another you could have a formula to add them. Soif you had values in column A, say in cell B2 you could add 1.5 toA2 like this ... to the new one. If there is a formula in thecell, it will put +1.5 at the end of it.

In Excel, how can I add a popup definition to each column header in the header row?

Description : In Excel, how can I add a popup definition to each column header in the header row?

Last Answer : I typically right click the cell and scroll down to select Add Comment. It will add a little red triangle in the upper right corner of the cell that one must click to read the comment. ... triangle that Excel puts in the upper left corner if it suspects some weird calculation result in the cell.

Simplest way to convert a row into column in Excel?

Description : Simplest way to convert a row into column in Excel?

Last Answer : answer:Hi @Sassy009, welcome to ask-public! In Excel that is called Transpose. Here’s an explanation from Microsoft. Switch (transpose) columns and rows

Convert Excel cell data to a column header?

Description : Convert Excel cell data to a column header?

Last Answer : answer:From your question it's not entirely clear to me what you want to do. Obviously you want to differentiate one product (Product ID) from another. So, do you just want to change a listing that ... the Find text with , leaving you with only the product ID values. Was that what you wanted?

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Description : Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Last Answer : What kind of results are you looking for ? I.e. what are you comparing between test1 and test2 ? Also, I’m not sure I understand what are ‘value points’ ? And when you say ‘group all the students’ do you mean counts of students that got that level of score on the test?

Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Description : Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Last Answer : answer:Assuming you have a space or comma between the first and last names, you can use Data / Text to Columns. (I'm still using Excel 2000, so your commands on a more recent version may be ... as space , or comma, or whatever it is. The text will be broken into separate columns automatically.

In an Excel worksheet does a column typically contain information that is similar to a list?

Description : In an Excel worksheet does a column typically contain information that is similar to a list?

Last Answer : Yes it does, like a field in a database.

What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

How do I add a secondary x axis to a chart in excel 2008?

Description : How do I add a secondary x axis to a chart in excel 2008?

Last Answer : Click on the chart, then go to chart type, Custom Types, Line -Column on Two axes.

How do I automatically add the date to a MS Excel cell?

Description : How do I automatically add the date to a MS Excel cell?

Last Answer : You would want a macro, or if you hit Ctrl+; it automatically puts in the current date in the selected cell, and you can add the called left message afterward If you want to do a macro, you can record ... need to edit the macro to work for each line. So it might be easier to use the Ctrl+; shortcut

How do I add several graph lines into one graph in excel 2007?

Description : How do I add several graph lines into one graph in excel 2007?

Last Answer : If I understand your question correctly, I would paste the second data set into a column next to your first data set, and then expand the graph to include the second column. If Excel won’t let you do this, the spreadsheet feature in Google docs definitely will. Their graphs are super intuitive.

I want to add a page and/or a column to my tumblr?

Description : I want to add a page and/or a column to my tumblr?

Last Answer : I wanted to do the exact same with my Tumblr blog. Adding a column to the side is dependent on the coding that makes up the theme. Unless you know coding very well, adding one to a re existing theme is not an ... you more :( If you have any questions or need help I'd be happy to ask my SO for you!

How do I add a Facebook page to a Tweetdeck Column?

Description : How do I add a Facebook page to a Tweetdeck Column?

Last Answer : The newest version of tweetdeck has several buttons at the top left including the compose , twitter search , Tweetdeck directory , new twitter column , new Facebook column and new Myspace column ... ... the facebook icon and set up the account you want shown in it's own column. Pretty simple.

Add an ID column to an already existing MySQL table?

Description : Add an ID column to an already existing MySQL table?

Last Answer : I’m not an expert on MySQL [@stewartwb?], but in SQLServer that works just fine. Add the column and set the identity property and it autogenerates. What happens when you try that in MySQL? Do you get an error? or does it just not populate?

Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Description : Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Last Answer : No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used ... give an increase of 50 Rs. to all the books:Update library set price=price+50;

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

Where can I find a decorative fiberglass column to add to the front of my house?

Description : Where can I find a decorative fiberglass column to add to the front of my house?

Last Answer : Columbuilder.com will let you customize a decorative fiberglass column specifically for the front of your house. I just added two fiberglass columns to the front of my house, on my front porch, ... them from Worthington Millwork. They're exactly what I was looking for and match my house perfectly.

Use the add_group_column function to add a column to record group that was created at a design time?

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE