answersLogoWhite

0

Try this, substitute B2 and A2 with the cells you are trying to round =(ROUND(B2*96, 0)/96)-(ROUND(A2*96, 0)/96)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What do you get when you round 4583304 to the nearest thousand?

You get a total of 458300.


What is the past tense form of round?

Round is a regular verb so past and past participle are rounded.He rounded the total to the nearest dollar.


Does 15 round up to a total of 10 or 15?

15 rounds to 15 if you are rounding to the nearest whole number. If you are rounding to the nearest five, then 15 still rounds to 15. If you are rounding to the nearest ten, then 15 would round up to 20.


What to do if the money total has a repeating decimal?

round off to nearest one hundredth; for example 1.444444.. = 1.44


Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


Total number of formulas in Excel?

The amount of formulas that can be done in Excel is infinite.


Add and round the sum as indicated 3 254 7 241 and 6 754 round the sum to the nearest hundred?

My best guess is that you want the sum of 3,254 + 7,241 + 6,754, rounded to the nearest hundred. If that is the correct interpretation of the question, you should add the numbers first and then round the total; don't round the individual numbers before adding them. 3,254 + 7,241 + 6,754 = 17,249, which rounds to 17,200


A lab technician is mixing a solution and needs to convert 5 gallons to liters. Calculate the total liters. Round to the nearest hundredth.?

18.93 L


How can you Convert quarter hours to semester hour?

Divide the number of quarter hours by 1.5ex:qrt. hr sem hr.1 .672 1.343 24 2.67... ...10 6.6720 13.3430 2040 26.67To convert quarter hours into semester hours, add up ALL of the quarter hours and multiply the total by .67 (which is the same as multiplying by 2/3). You can round off the decimal.EXAMPLE: 40 quarter hours x .67 = 26.8 semester hours.To convert semester hours into quarter hours, you divide the total number of quarter hours by 1.5


What is 239.00 plus 8.25 tax?

$258.72 would be the total. You take the sale amount of $239.00 and multiply it by 1.0825 and it will give you the total of the sale and sales tax added and you have to round it to the nearest cent.


What is the answer if you round 219.49 and 279.97 and 234.95 to the nearest dollar then add?

Well, darling, if we round 219.49, 279.97, and 234.95 to the nearest dollar, we get 219, 280, and 235, respectively. Adding those rounded numbers together gives you a grand total of 734. So, go ahead and treat yourself with that extra dollar you saved from rounding!


How can you do the total of date in excel?

ask me plz...