| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Different kind of rounding
I need help with this one...
If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different kind of rounding
With a value in A20:
=IF(RIGHT(1000*A20,1)=0,A20,ROUNDUP(A20,2)) -- Gary''s Student - gsnu200821 "Sarah_Lund" wrote: I need help with this one... If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different kind of rounding
=IF(ROUND(x,3)=ROUND(x,2),ROUND(x,2),ROUNDUP(x,2))
Jerry "Sarah_Lund" wrote: I need help with this one... If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different kind of rounding
or =ROUNDUP(ROUND(x,3),2) ?
-- David Biddulph "Jerry W. Lewis" wrote in message ... =IF(ROUND(x,3)=ROUND(x,2),ROUND(x,2),ROUNDUP(x,2)) Jerry "Sarah_Lund" wrote: I need help with this one... If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different kind of rounding
On Dec 21, 7:56*am, Sarah_Lund
wrote: If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 Caveat emptor: it is not clear what you want to do with 4.2405, for example. A literal interpretation would say that you want 4.24. But perhaps you mean "if the 3rd digit after the decimal point after first rounding to 3 decimal places". It would behoove you to test any solution with 4.2405 to be sure it is giving you what you want. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Different kind of rounding
I am apparently missing something in the OP's question, but I would think
ROUNDUP would work directly. Doesn't... =ROUNDUP(A20,2) do the same thing as your formula? If not, what am I overlooking? -- Rick (MVP - Excel) "Gary''s Student" wrote in message ... With a value in A20: =IF(RIGHT(1000*A20,1)=0,A20,ROUNDUP(A20,2)) -- Gary''s Student - gsnu200821 "Sarah_Lund" wrote: I need help with this one... If the 3rd digit after the decimal is not a zero, I need to round up the 2nd digit, otherwise leave the number as is Examples: 4.240 would be 4.24 4.241 would be 4.25 I'd like to be able to do this in one step/one formula. Any suggestions?? Thank you, Sarah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?? Some kind of look up function - Help and Thanks A Lot! | Excel Worksheet Functions | |||
| Don't know what kind of question this is? | Excel Discussion (Misc queries) | |||
| Hi Everyone! Im a Student so please be kind... | Charts and Charting in Excel | |||
| kind of chart? | Charts and Charting in Excel | |||
| Is this kind of count possible?... | Excel Worksheet Functions | |||
Linear Mode
