Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

division discrepency

0

I am using Excell to calculate codes to enter into an e2prom to generate frequencies in a radio being used for ham radio purposes. I divide the required frequency by 0.00625 to get a number which is converted to hexidecimal. When I divide 145.00 by 0.00625 I get 23200 which is correct but when I divide the next frequency of 145.0125 I get 23201 instead of 23202 then the next frequency is 145.025 and dividing by 0.00625 the result is 23204 which is correct. Before I had excell I used the spreadsheet in Microsoft Works and using the easycalc function in that the results always were correct. Can anyone help please.

Puzzled 

exceldata-validation
MS Office Version: Excell 2013
posted by: puzzled on Tue Jul 12, 2016 at 6:48 am
Answer
Discuss

Answers

0

I get the correct Answer and I'm using Excel 2010.

Maybe there is a rounding issue that you are not seeing.

In the cells with the numbers, select them, go to the Home tab and in the Number box click Increase Decimal a few times. Make sure you can see everything and then re-try the calculations.

posted by: don (rep: 1989) on Tue Jul 12, 2016 at 10:20 am
Discuss
0

I'm not sure if I understood the question, so according to that:

When you divide two numbers by formula

Like 145 by 0.00625 don't take the answer value and divide it again 

But reference it by that formula

for example

If 145 in cell A1 and 0.00625 in cell B1 formula should be =A1/B1 in cell C1

and not =145/0.00625

And the same thing if you divide that value so you put after that in cell D1 for example =C1/B1

And be sure to format the cell to see the decimals and also don't use the Round and other formulas that do similar thing

posted by: MRVMV (rep: 52) on Tue Jul 12, 2016 at 12:59 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login