Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas an uimhir a shlánú go dtí an 5/10/50/100 is gaire in Excel?

Uaireanta, b’fhéidir gur mhaith leat uimhreacha a thiontú go 5/10/50/100 is gaire le ríomh in Excel. Soláthraíonn an Rang Teagaisc seo roinnt foirmlí simplí chun uimhreacha a shlánú go dtí an uimhir shonrach is gaire, agus tugann sé na foirmlí isteach go huimhreacha cruinn go dtí an chéad cheann eile nó an ceann is gaire.
babhta doc go dtí an ceann is gaire 5 10 50 1

Uimhreacha babhta go dtí an 5 is gaire

 


mboilgeog cheart gorm saighead Uimhreacha babhta go dtí an 5 is gaire

Babhta go dtí an 5/10/50/100 is gaire

Babhta go dtí an 5 is gaire = ROUND (A2 / 5,0) * 5
Babhta go dtí an 10 is gaire = ROUND (A2 / 10,0) * 10
Babhta go dtí an 50 is gaire = ROUND (A2 / 50,0) * 50
Babhta go dtí an 100 is gaire = ROUND (A2 / 100,0) * 100

babhta doc go dtí an ceann is gaire 5 10 50 2

Nóta:

Is féidir leat an fhoirmle seo a úsáid freisin = MROUND (A2,5) chun na huimhreacha a shlánú go dtí an 5 is gaire.

Babhta go dtí an chéad cheann eile is gaire 5/10/50/100

Babhta go dtí an chéad 5 eile is gaire = ROUNDUP (A2 / 5,0) * 5
Babhta go dtí an chéad 10 eile is gaire = ROUNDUP (A2 / 10,0) * 10
Babhta go dtí an chéad 50 eile is gaire = ROUNDUP (A2 / 50,0) * 50
Babhta go dtí an chéad 100 eile is gaire = ROUNDUP (A2 / 100,0) * 100

babhta doc go dtí an ceann is gaire 5 10 50 3

Babhta go dtí an ceann deireanach is gaire 5/10/50/100

Babhta go dtí an 5 deireanach is gaire = ROUNDDOWN (A2 / 5,0) * 5
Babhta go dtí an 10 deireanach is gaire = ROUNDDOWN (A2 / 10,0) * 10
Babhta go dtí an 50 deireanach is gaire = ROUNDDOWN (A2 / 50,0) * 50
Babhta go dtí an 100 deireanach is gaire = ROUNDDOWN (A2 / 100,0) * 100

babhta doc go dtí an ceann is gaire 5 10 50 4


Go héasca Babhta uimhreacha suas nó síos nó go fiú in Excel gan foirmle

Mar is eol dúinn, tá roinnt foirmlí ann ar féidir uimhreacha a chothromú, ach níl tú ag iarraidh foirmle a úsáid chun uimhreacha a shlánú, is féidir le fóntais Babhta Kutools le haghaidh Excel fabhar a thabhairt duit. Cliceáil le haghaidh triail saor in aisce 30 lá!
babhta doc
Kutools for Excel: le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá.
 


Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun 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 · 3 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).