Note: The other languages of the website are Google-translated. Back to English
Mewngofnodi  \/ 
x
or
x
Cofrestru  \/ 
x

or

Sut i dalgrynnu rhif i'r 5/10/50/100 agosaf yn Excel?

Weithiau, efallai yr hoffech chi drosi rhifau i'r 5/10/50/100 agosaf i'w cyfrif yn Excel. Mae'r Tiwtorial hwn yn darparu rhai fformiwlâu syml i rifau crwn i'r rhif penodol agosaf, a hefyd yn cyflwyno'r fformwlâu i rifau crwn i'r un nesaf neu'r un agosaf.
rownd doc i'r agosaf 5 10 50 1

Rhifau crwn i'r 5 agosaf

 


swigen dde glas saeth Rhifau crwn i'r 5 agosaf

Rownd i'r agosaf 5/10/50/100

Rownd i'r 5 agosaf = ROWND (A2 / 5,0) * 5
Rownd i'r 10 agosaf = ROWND (A2 / 10,0) * 10
Rownd i'r 50 agosaf = ROWND (A2 / 50,0) * 50
Rownd i'r 100 agosaf = ROWND (A2 / 100,0) * 100

rownd doc i'r agosaf 5 10 50 2

Nodyn:

Gallwch hefyd ddefnyddio'r fformiwla hon = MROUND (A2,5) i dalgrynnu rhifau i'r 5 agosaf.

Rownd i'r 5/10/50/100 agosaf

Rownd i'r 5 agosaf nesaf = ROUNDUP (A2 / 5,0) * 5
Rownd i'r 10 agosaf nesaf = ROUNDUP (A2 / 10,0) * 10
Rownd i'r 50 agosaf nesaf = ROUNDUP (A2 / 50,0) * 50
Rownd i'r 100 agosaf nesaf = ROUNDUP (A2 / 100,0) * 100

rownd doc i'r agosaf 5 10 50 3

Rownd i'r olaf agosaf 5/10/50/100

Rownd i'r 5 agosaf olaf = ROUNDDOWN (A2 / 5,0) * 5
Rownd i'r 10 agosaf olaf = ROUNDDOWN (A2 / 10,0) * 10
Rownd i'r 50 agosaf olaf = ROUNDDOWN (A2 / 50,0) * 50
Rownd i'r 100 agosaf olaf = ROUNDDOWN (A2 / 100,0) * 100

rownd doc i'r agosaf 5 10 50 4


Yn hawdd Rhifau crwn i fyny neu i lawr neu hyd yn oed yn Excel heb fformiwla

Fel y gwyddom, mae yna rai fformiwlâu sy'n gallu talgrynnu rhifau, ond nid ydych chi am ddefnyddio fformiwla i dalgrynnu rhifau, gall cyfleustodau Rownd Kutools ar gyfer Excel wneud ffafr i chi. Cliciwch am 30 diwrnod o dreial am ddim!
rownd doc
Kutools ar gyfer Excel: gyda mwy na 300 o ychwanegion Excel defnyddiol, am ddim i geisio heb unrhyw gyfyngiad mewn 30 diwrnod.
 


Yr Offer Cynhyrchedd Swyddfa Gorau

Mae Kutools for Excel yn Datrys y rhan fwyaf o'ch Problemau, ac yn Cynyddu Eich Cynhyrchedd 80%

  • Ailddefnyddio: Mewnosod yn gyflym fformwlâu cymhleth, siartiau ac unrhyw beth rydych chi wedi'i ddefnyddio o'r blaen; Amgryptio Celloedd gyda chyfrinair; Creu Rhestr Bostio ac anfon e-byst ...
  • Bar Fformiwla Gwych (golygu llinellau lluosog o destun a fformiwla yn hawdd); Cynllun Darllen (darllen a golygu nifer fawr o gelloedd yn hawdd); Gludo i'r Ystod Hidlo...
  • Uno Celloedd / Rhesi / Colofnau heb golli Data; Cynnwys Celloedd Hollt; Cyfuno Rhesi / Colofnau Dyblyg... Atal Celloedd Dyblyg; Cymharwch y Meysydd...
  • Dewiswch Dyblyg neu Unigryw Rhesi; Dewiswch Blank Rows (mae pob cell yn wag); Darganfyddiad Gwych a Darganfyddiad Niwlog mewn Llawer o Lyfrau Gwaith; Dewis ar Hap ...
  • Copi Union Celloedd Lluosog heb newid cyfeirnod fformiwla; Auto Creu Cyfeiriadau i Daflenni Lluosog; Mewnosod Bwledi, Blychau Gwirio a mwy ...
  • Testun Detholiad, Ychwanegu Testun, Tynnu yn ôl Swydd, Tynnwch y Gofod; Creu ac Argraffu Subtotals Paging; Trosi rhwng Cynnwys a Sylwadau Celloedd...
  • Hidlo Super (arbed a chymhwyso cynlluniau hidlo i ddalenni eraill); Trefnu Uwch yn ôl mis / wythnos / dydd, amlder a mwy; Hidlo Arbennig gan feiddgar, italig ...
  • Cyfuno Llyfrau Gwaith a Thaflenni Gwaith; Uno Tablau yn seiliedig ar golofnau allweddol; Rhannwch Ddata yn Daflenni Lluosog; Trosi Swp xls, xlsx a PDF...
  • Mwy na 300 o nodweddion pwerus. Yn cefnogi Swyddfa / Excel 2007-2019 a 365. Yn cefnogi pob iaith. Defnydd hawdd yn eich menter neu sefydliad. Nodweddion llawn treial am ddim 30 diwrnod. Gwarant arian yn ôl 60 diwrnod.
tab kte 201905

Mae Tab Office yn Dod â rhyngwyneb Tabbed i'r Swyddfa, a Gwneud Eich Gwaith yn Haws o lawer

  • Galluogi golygu a darllen tabbed yn Word, Excel, PowerPoint, Cyhoeddwr, Mynediad, Visio a Phrosiect.
  • Agor a chreu dogfennau lluosog mewn tabiau newydd o'r un ffenestr, yn hytrach nag mewn ffenestri newydd.
  • Yn cynyddu eich cynhyrchiant 50%, ac yn lleihau cannoedd o gliciau llygoden i chi bob dydd!
gwaelod officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Amber · 2 months ago
    may i know how to set a formula which include 2 criteria, 1/2 remain 1/2 and every 3/4 round up to 1, e.g. 3/4->1, 1-3/4->2, 2-3/4->3
  • To post as a guest, your comment is unpublished.
    TIFFANIC · 2 months ago
    I want to round up in the same columm,

    Example : 1201 to be 1250
  • To post as a guest, your comment is unpublished.
    Salim · 2 years ago
    I want to round up or down decimal places in the same columm,

    Example : 12.49 to be 12 and 12.50 to be 13
  • To post as a guest, your comment is unpublished.
    jdamianv113 · 3 years ago
    I want to generate an IF formula that will help me round up or down decimals in the same column

    example :

    Cell A1 ----- 6.13 want it to round up to 6.49
    Cell A2 ----- 6.74 want it to round up to 6.79
    Cell A3 ----- 6.84 want it to round down to 6.79
    • To post as a guest, your comment is unpublished.
      Sunny · 3 years ago
      Sorry, Jose, I do not understand your round up and down rule.
  • To post as a guest, your comment is unpublished.
    Jose · 3 years ago
    I want to generate an IF formula that will help me round up or down decimals in the same column

    example :

    Cell A1 ----- 6.13 want it to round up to 6.49
    Cell A2 ----- 6.74 want it to round up to 6.79
    Cell A3 ----- 6.84 want it to round down to 6.79

  • To post as a guest, your comment is unpublished.
    sachin · 3 years ago
    HOW TO ROUNDUP 2.5 =5 AND 7.8=10
    • To post as a guest, your comment is unpublished.
      Sanjay · 3 years ago
      Use this formula =mround("cell address where 2.5 or 7.8 is written in the excel sheet",5) i.e. if 2.5 is written in cell A1 then =mround(a1,5) and if 7.8 is written in cell B1 then =mround(b1,5)
    • To post as a guest, your comment is unpublished.
      Sunny · 3 years ago
      Sorry I have no idea.
  • To post as a guest, your comment is unpublished.
    Darshan · 4 years ago
    i need formula that will write 95000 as 90000 or 87000 as 80000, if figure 89000 then it should be 90000.
    Means only 9 or above then should mround to 10 otherwise not
    • To post as a guest, your comment is unpublished.
      Sunny · 4 years ago
      You can go to our forum to submit your question, someone may answer you. https://www.extendoffice.com/forum.html
  • To post as a guest, your comment is unpublished.
    Chandrashekhar gupta · 4 years ago
    HOW TO ROUND 50.49 =50 AND 50.50=60 AND 90.49=90 AND 90.50=100
    • To post as a guest, your comment is unpublished.
      Sunny · 4 years ago
      Hello, you just need this formula =ROUND(reference, 0).
  • To post as a guest, your comment is unpublished.
    wellington · 4 years ago
    well articulated article, worked for me thanks
  • To post as a guest, your comment is unpublished.
    Lisa · 4 years ago
    Can I use this in a formula? For example, I want the formula =(C118*D118)+50, but I want the answer to round up to the nearest five. So if C118 is 216, and D118 is 13, I want 2808 + 50 to round up to 2860. I'd like to to it all in the same column rather than adding a column. Thanks!
    • To post as a guest, your comment is unpublished.
      Sanjay · 3 years ago
      use this formula =ceiling((c118*d118)+50,10)
  • To post as a guest, your comment is unpublished.
    Accounts · 5 years ago
    Is there a formula that you can set so that decimals are rounded up to the nearest .05? i.e. 3.13 = 3.15 OR 2.11 = 2.15
    • To post as a guest, your comment is unpublished.
      CH · 4 years ago
      =ROUNDUP(A2/0.05,0)*0.05
      • To post as a guest, your comment is unpublished.
        Daniel Gunter · 4 years ago
        Can I roundup to the nearest even number?
        • To post as a guest, your comment is unpublished.
          Sunny · 4 years ago
          Maybe you can try =EVEN(A1).