Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Rounding numbers and something else (https://www.askmehelpdesk.com/showthread.php?t=517378)

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

    http://www.pttbn.com/media/downloads/1.png

    Thanks
  • Oct 17, 2010, 12:37 AM
    JBeaucaire

    Try this:

    =IF(A19<=10000, A19, MOD(A19,1000) + 9000)
  • Oct 17, 2010, 02:52 AM
    Pajoooo
    What to say? Man is a genius.

    Thanks.

    • All times are GMT -7. The time now is 03:48 AM.