Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Len Function Help
Hi,
I have this formula which works well, but the 3-len part needs to be dependent on another cells content. Is it possible to have the formula automatically accommodate for this? Eg =ROUND(I36-I37,3-LEN(INT(Q16))) in cell Q16 is a number 0.010 as displayed, and the sum of i36-i37= 0.007 I need the formula to say ok the minimum division size is in multiples of Q16 (0.010) and change the 0.007 to either up or down depending on the calculation. This works currently, but the figure in Q16 can be 0.1 or 0.00001 etc, and the sum in i36-i37 could be anything also as it is a calculated error figure. I need the formula to be able to adapt automatically to the reference DP in Q16. Namely the "3-" part in the formula needs to accomodate for the Q16 number format changing. Is this achievable? Thanks in advance, Aaron. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round function in If statement | Excel Discussion (Misc queries) | |||
An Inquirey on the Round function | Excel Worksheet Functions | |||
how do i set up round function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |