3 Replies - 601 Views - Last Post: 10 October 2015 - 12:56 AM

#1 ichabodgrant  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 25-September 14

Microsoft Excel 2013 function problem

Posted 09 October 2015 - 07:56 PM

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.

Is This A Good Question/Topic? 0
  • +

Replies To: Microsoft Excel 2013 function problem

#2 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2343
  • View blog
  • Posts: 9,398
  • Joined: 03-December 12

Re: Microsoft Excel 2013 function problem

Posted 09 October 2015 - 08:11 PM

How well do you know VBA? Getting started with VBA
Was This Post Helpful? 0
  • +
  • -

#3 ichabodgrant  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 24
  • Joined: 25-September 14

Re: Microsoft Excel 2013 function problem

Posted 09 October 2015 - 10:30 PM

nothing.
Was This Post Helpful? 0
  • +
  • -

#4 andrewsw  Icon User is offline

  • say what now
  • member icon

Reputation: 6409
  • View blog
  • Posts: 25,903
  • Joined: 12-December 12

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 / * ^ ?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1