Hi everyone.

I am currently doing a lab report and it involves two thousands sth data.

It is asked to plot a graph using these data.

However, the units of the data are inappropriate. I have to change the units by doing some simple division and multiplication to ALL DATA.

It is extremely difficult for me to do this by hand. But I am not familiar with the functions in Excel. I have tried using DIVISION and PRODUCT but it often tells me that there are errors. Can anyone teach me how to divide all the data by the same constant number?

e.g. I have data: 10.03, 11.12, 12.08, 13.11, 14.14, 15.10, 16.09, ...

Suppose these are in unit kN. I have to change them into MPa. The cross-sectional area is known, let's say it's 0.001 m^2. So I need to divide all the data by 0.001 m^2. The result may not be in MPa, so I still need further processing.

# Microsoft Excel 2013 function problem

Page 1 of 1## 3 Replies - 621 Views - Last Post: 10 October 2015 - 12:56 AM

##
**Replies To:** Microsoft Excel 2013 function problem

### #2

## Re: Microsoft Excel 2013 function problem

Posted 09 October 2015 - 08:11 PM

How well do you know VBA? Getting started with VBA

### #3

## Re: Microsoft Excel 2013 function problem

Posted 09 October 2015 - 10:30 PM

nothing.

### #4

## Re: Microsoft Excel 2013 function problem

Posted 10 October 2015 - 12:56 AM

Why are you jumping to functions, what's wrong with simple operators / * ^ ?

Page 1 of 1