Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Sandy,
Neither entries in E4 or C7 are the result of calculations. My result was originally .01. I am now getting .02. Thanks to all who helped. ....Will Sandy Mann wrote: there should be a + in front of the E4 Why? It works for me without the + and I believe that it is not required. To Will: Is the entry in either E4 or C7 the result of a calculation? It may be that it is displaying as say 0.74 but the value held in the cell is actually a different value. What result are you getting returned? -- HTH Sandy with @tiscali.co.uk "annie" wrote in message ... your formula should be =ROUNDUP(+E4*C7,2) there should be a + in front of the E4 "Will" wrote: This will probably be an easy question, but I can't figure it out. I want to round up a cell that contains a formula. Ex. =E4*C7 Where E4 = 1.53% C7 = .74 I am currently using this formula: =ROUNDUP(E4*C7,2) Shouldn't the answer be .02? Thank you, ....Will |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |