Ask Experts Questions for FREE Help !
Ask
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #1

    Oct 16, 2010, 04:23 PM
    Rounding numbers and something else
    Help please,
    View Image,



    Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 17, 2010, 12:37 AM

    Try this:

    =IF(A19<=10000, A19, MOD(A19,1000) + 9000)
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #3

    Oct 17, 2010, 02:52 AM
    What to say? Man is a genius.

    Thanks.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Rounding numbers and something else [ 2 Answers ]

Help, please, View attachement. Thanks

Rounding numbers [ 2 Answers ]

2,782 rounded the highest

Rounding numbers [ 2 Answers ]

What is 12.17556 to the nearest ten-thousandth?

Rounding numbers to specific criteria [ 3 Answers ]

Hi, I am working on spreadsheets with values that I want to be able to round up based on this criteria: If the number ends in 0,1,2, then round to nearest 0 If the number ends in 3,4,5, then round to nearest 5 If the number ends in 6,7,8,9 then round to nearest 9 The spreadsheet contains...

View more questions Search