i've got some excel questions for you guys (and gals if you want to help too)
1) how do i round of small values to zero (without changing the number of decimals in the cell, etc.) for example, i have the value 6.63e-12, which is basically negligable, and it just clutters up my spreadsheet. how do i get rid of this?
2) is there any way to make excel work in degrees instead of in radians (short of multiplying every degree measurement by pi/180)?
on a sidenote though, something you guys might find interesting. 30-40 years ago, most of the more complex aerodynamics problems required "supercomputers" to calculate and would often take days to compute. now, a lot of work is just done in excel. and it works just as good. that is if you don't forget what units you're using
1) how do i round of small values to zero (without changing the number of decimals in the cell, etc.) for example, i have the value 6.63e-12, which is basically negligable, and it just clutters up my spreadsheet. how do i get rid of this?
2) is there any way to make excel work in degrees instead of in radians (short of multiplying every degree measurement by pi/180)?
on a sidenote though, something you guys might find interesting. 30-40 years ago, most of the more complex aerodynamics problems required "supercomputers" to calculate and would often take days to compute. now, a lot of work is just done in excel. and it works just as good. that is if you don't forget what units you're using
Facebook
Twitter