Questions & Answers for: formula round excel

cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full number the simpliest solution is to change cell formatint to NUMBER and set the decimal places to 0

...From the example you provided above, you could use the following formula: =ROUND(SUM(A1:A4)*1.07,2) The final "2" specifies that you want to display two digits to the right of the decimal

...formula I have a round disc 1800mm in diameter I want to calculate in excel the surface area of 1800mm in m2 and i have 38 discs. what is the total surface area inn square metres is it 1800*3.14=5652 ...

Excel calculations I currently have a work hours time sheet which is in a time format, when entering the hours everything apears correclty. However, for my totals for each day unless the time is ...

...it would be something like the following: =SUM((VLOOKUP(AL28,BJ:BK,2,FALSE)-(BH28))) (or the other way round). Thanks CJ Press the F1 function key whilst using Excel and the help files will guide

...formula to me. Please help. I am aiming to use this in printing, to genarate a "lotoery" type of ticket. you can use the Round function as below - it rounds out the decimal to 0 places, which gives ...

...round? etc. In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your ...

...Excel 2007. I need it to stop rounding time. Here is the formula: =IF((OR(C14="",C13="")),0,IF((C14 format the cells that contains times and net time worked as time format you using Enter the simple ...

...round up to a .95. Is there a formula that would figure the retail and round to .95? =INT(A1)+0.95 With A1 being the reference to the cell you wish to round up What that does is first round down the ...

...round a formula result in the same cell? In cell A2 I take the number 19.00 from cell A1 and apply the formula =A1-0.75 resulting in a sum of $18.25 in A2 which I want to round down to $18.00 in cell ...