More like RoundDown. I have sent my agents through enemy territory for this!
May 6, 2026 at 9:08 PM
More like RoundDown. I have sent my agents through enemy territory for this!
Optimist: The cup is half full
Pessimist: The cup is half empty
Spreadsheet optimist people: =if(roundup(cup,0)=1,"Full","Empty")
Spreadsheet pessimist people: =if(rounddown(cup,0)=1,"Full","Empty")
Pessimist: The cup is half empty
Spreadsheet optimist people: =if(roundup(cup,0)=1,"Full","Empty")
Spreadsheet pessimist people: =if(rounddown(cup,0)=1,"Full","Empty")
Optimist: The cup is half full
Pessimist: The cup is half empty
Media theorist: The cup is a medium of transport and transmission, and its content is always another medium
Pessimist: The cup is half empty
Media theorist: The cup is a medium of transport and transmission, and its content is always another medium
Optimist: The cup is half full
Pessimist: The cup is half empty
Historian: The cup can teach you a lot of things that you do not want to know
Pessimist: The cup is half empty
Historian: The cup can teach you a lot of things that you do not want to know
August 22, 2026 at 9:24 AM
Optimist: The cup is half full
Pessimist: The cup is half empty
Spreadsheet optimist people: =if(roundup(cup,0)=1,"Full","Empty")
Spreadsheet pessimist people: =if(rounddown(cup,0)=1,"Full","Empty")
Pessimist: The cup is half empty
Spreadsheet optimist people: =if(roundup(cup,0)=1,"Full","Empty")
Spreadsheet pessimist people: =if(rounddown(cup,0)=1,"Full","Empty")
=ROUNDDOWN(1d6/2) has a really interesting distribution [1 1 1 2 2 3], just too bad it's too inconvenient for most rolls.
January 16, 2026 at 3:29 AM
=ROUNDDOWN(1d6/2) has a really interesting distribution [1 1 1 2 2 3], just too bad it's too inconvenient for most rolls.
I just found out that mine isn't to-date accrual, and automatically turns over at my hire date anniversary.
I did create a spreadsheet that calculated it for me: =(((1+DATEDIF(Hire_Date,Today's_or_Entered_Date","y"))*12)*(Accrual_Rate_per_day)+((ROUNDDOWN(D2,0)*(ROUNDDOWN(D2,0)+1)/2)))*Daily_Hours
I did create a spreadsheet that calculated it for me: =(((1+DATEDIF(Hire_Date,Today's_or_Entered_Date","y"))*12)*(Accrual_Rate_per_day)+((ROUNDDOWN(D2,0)*(ROUNDDOWN(D2,0)+1)/2)))*Daily_Hours
April 29, 2026 at 9:08 PM
I just found out that mine isn't to-date accrual, and automatically turns over at my hire date anniversary.
I did create a spreadsheet that calculated it for me: =(((1+DATEDIF(Hire_Date,Today's_or_Entered_Date","y"))*12)*(Accrual_Rate_per_day)+((ROUNDDOWN(D2,0)*(ROUNDDOWN(D2,0)+1)/2)))*Daily_Hours
I did create a spreadsheet that calculated it for me: =(((1+DATEDIF(Hire_Date,Today's_or_Entered_Date","y"))*12)*(Accrual_Rate_per_day)+((ROUNDDOWN(D2,0)*(ROUNDDOWN(D2,0)+1)/2)))*Daily_Hours
How to Use the ROUNDDOWN Formula in Excel
#Excel, #MicrosoftExcel, #ExcelTutorial, #ExcelFunctions, #ROUNDDOWN, #ExcelFormula, #ExcelTips, #ExcelMathFunctions, #DataAnalysis, #SpreadsheetTips, #LearnExcel, #ExcelForBeginners, #OfficeSkills,
#Excel, #MicrosoftExcel, #ExcelTutorial, #ExcelFunctions, #ROUNDDOWN, #ExcelFormula, #ExcelTips, #ExcelMathFunctions, #DataAnalysis, #SpreadsheetTips, #LearnExcel, #ExcelForBeginners, #OfficeSkills,
May 13, 2026 at 5:27 AM
How to Use the ROUNDDOWN Formula in Excel
#Excel, #MicrosoftExcel, #ExcelTutorial, #ExcelFunctions, #ROUNDDOWN, #ExcelFormula, #ExcelTips, #ExcelMathFunctions, #DataAnalysis, #SpreadsheetTips, #LearnExcel, #ExcelForBeginners, #OfficeSkills,
#Excel, #MicrosoftExcel, #ExcelTutorial, #ExcelFunctions, #ROUNDDOWN, #ExcelFormula, #ExcelTips, #ExcelMathFunctions, #DataAnalysis, #SpreadsheetTips, #LearnExcel, #ExcelForBeginners, #OfficeSkills,
And it's all thanks to this bad boy;
=if(A4="","", concatenate(rounddown(sum(B4:I4)/60,0)," hours and ",(rounddown(sum(B4:I4))-(60*rounddown(sum(B4:I4)/60)))," minutes"))
=if(A4="","", concatenate(rounddown(sum(B4:I4)/60,0)," hours and ",(rounddown(sum(B4:I4))-(60*rounddown(sum(B4:I4)/60)))," minutes"))
October 26, 2024 at 1:55 AM
And it's all thanks to this bad boy;
=if(A4="","", concatenate(rounddown(sum(B4:I4)/60,0)," hours and ",(rounddown(sum(B4:I4))-(60*rounddown(sum(B4:I4)/60)))," minutes"))
=if(A4="","", concatenate(rounddown(sum(B4:I4)/60,0)," hours and ",(rounddown(sum(B4:I4))-(60*rounddown(sum(B4:I4)/60)))," minutes"))
小数点以下すべてROUNDDOWNで切り捨てるぞ
February 5, 2025 at 11:11 AM
小数点以下すべてROUNDDOWNで切り捨てるぞ
“I’m the only premier in the history of Ontario with a zero* expense account”
* - ROUNDDOWN(44395,-6)
* - ROUNDDOWN(44395,-6)
July 29, 2026 at 1:07 AM
“I’m the only premier in the history of Ontario with a zero* expense account”
* - ROUNDDOWN(44395,-6)
* - ROUNDDOWN(44395,-6)
Based on what appears to be a lack of planning and understanding, I think Rubio may need to go to Bessent to help balance VE capital account in Feb/March. I found:
liquid reserves ~$3-5B @ Nov25. (inferred, published ~$13B is false)
Food/Med/Fuel imports @ ~$250M/week. (2024 imports/52/rounddown)
liquid reserves ~$3-5B @ Nov25. (inferred, published ~$13B is false)
Food/Med/Fuel imports @ ~$250M/week. (2024 imports/52/rounddown)
January 12, 2026 at 10:24 PM
Based on what appears to be a lack of planning and understanding, I think Rubio may need to go to Bessent to help balance VE capital account in Feb/March. I found:
liquid reserves ~$3-5B @ Nov25. (inferred, published ~$13B is false)
Food/Med/Fuel imports @ ~$250M/week. (2024 imports/52/rounddown)
liquid reserves ~$3-5B @ Nov25. (inferred, published ~$13B is false)
Food/Med/Fuel imports @ ~$250M/week. (2024 imports/52/rounddown)
3月の給与から健康保険・厚生年金保険の保険料率が変わるので検算シートを libreoffice のcalcで作っていた。
これでいいかの検算をこれまでの計算に当てはめてよさそうに見える。
roundup関数とrounddown関数のお世話になった。
これでいいかの検算をこれまでの計算に当てはめてよさそうに見える。
roundup関数とrounddown関数のお世話になった。
March 21, 2024 at 9:27 AM
3月の給与から健康保険・厚生年金保険の保険料率が変わるので検算シートを libreoffice のcalcで作っていた。
これでいいかの検算をこれまでの計算に当てはめてよさそうに見える。
roundup関数とrounddown関数のお世話になった。
これでいいかの検算をこれまでの計算に当てはめてよさそうに見える。
roundup関数とrounddown関数のお世話になった。
As a former head of purchasing for a company that was insanely successful before it became insanely broke, everyone needs to stop hurting me.
Whoever invented the ROUND and ROUNDDOWN functions in Excel should never encounter me, for their own sake.
Whoever invented the ROUND and ROUNDDOWN functions in Excel should never encounter me, for their own sake.
January 14, 2026 at 10:10 PM
As a former head of purchasing for a company that was insanely successful before it became insanely broke, everyone needs to stop hurting me.
Whoever invented the ROUND and ROUNDDOWN functions in Excel should never encounter me, for their own sake.
Whoever invented the ROUND and ROUNDDOWN functions in Excel should never encounter me, for their own sake.
Just found this for more precision: =IF(NOT(ISNUMBER(M19)),”n/a”,IF(OR(M19>=1,M19<=-1),ROUNDDOWN(M19,0)&"'-"&TEXT(MROUND(MOD(ABS(M19*12),12),1/16),"0 ##/###")&"""",TEXT(MROUND(ABS(M19*12),1/16)*SIGN(M19),"# ##/###")&""""))
March 13, 2025 at 6:16 PM
Just found this for more precision: =IF(NOT(ISNUMBER(M19)),”n/a”,IF(OR(M19>=1,M19<=-1),ROUNDDOWN(M19,0)&"'-"&TEXT(MROUND(MOD(ABS(M19*12),12),1/16),"0 ##/###")&"""",TEXT(MROUND(ABS(M19*12),1/16)*SIGN(M19),"# ##/###")&""""))
Αυτή η φάση λέγεται chicken and egg . Δηλαδή: Για να βρεις δουλειά πρέπει να έχεις εξασφαλίσει σπίτι, αλλά για να έχεις εξασφαλίσει σπίτι πρέπει να έχεις και δουλειά. Το κόστος ζωής Αθήνα είναι υψηλό που σημαίνει ότι για να έχεις και αξιόλογη ζωή θες 1300+ ( rounddown). Εγώ στη θέση σου 👇
July 15, 2025 at 7:02 AM
Αυτή η φάση λέγεται chicken and egg . Δηλαδή: Για να βρεις δουλειά πρέπει να έχεις εξασφαλίσει σπίτι, αλλά για να έχεις εξασφαλίσει σπίτι πρέπει να έχεις και δουλειά. Το κόστος ζωής Αθήνα είναι υψηλό που σημαίνει ότι για να έχεις και αξιόλογη ζωή θες 1300+ ( rounddown). Εγώ στη θέση σου 👇
The MAGA fight for Governor of Florida has turned into a sling fest. Fishback is is in the rounddown for Georgia and has called Donald's a slave for busiiness interests, and has refused to apology because Donald's family were never slaves in America. Put your dudes up guys and fight it out.
Trump ally 'getting a taste of his own MAGA medicine' with smears from GOP rival: column
The Republican gubernatorial primary in Florida has gotten off to an ugly start.GOP candidate James Fishback has fired off some odious smears against front-runner Byron Donalds, a Republican congressm...
www.rawstory.com
December 30, 2025 at 5:13 PM
The MAGA fight for Governor of Florida has turned into a sling fest. Fishback is is in the rounddown for Georgia and has called Donald's a slave for busiiness interests, and has refused to apology because Donald's family were never slaves in America. Put your dudes up guys and fight it out.
Ikke hør på meg. Jeg er sjuk. Jeg kontrollregner skatten for moro skyld, ett år var det et avvik på mitt excelark og skatteetatens fasit på 1 kr, da brukte jeg et par timer på å finne ut at jeg hadde brukt feil avrundingsmetode i en formel (=ROUND istedet for =ROUNDDOWN).
May 4, 2026 at 8:15 PM
Ikke hør på meg. Jeg er sjuk. Jeg kontrollregner skatten for moro skyld, ett år var det et avvik på mitt excelark og skatteetatens fasit på 1 kr, da brukte jeg et par timer på å finne ut at jeg hadde brukt feil avrundingsmetode i en formel (=ROUND istedet for =ROUNDDOWN).
Right of course the Excel function was =rounddown(((if(C2=1,"2",if(C2=2,"5",if(C2=3,"9",if(C2=4,"14",if(C2=5,"22")))))*B2)/(4*A2)),0) how could that be complicated
November 26, 2025 at 4:04 AM
Right of course the Excel function was =rounddown(((if(C2=1,"2",if(C2=2,"5",if(C2=3,"9",if(C2=4,"14",if(C2=5,"22")))))*B2)/(4*A2)),0) how could that be complicated
Excelの四捨五入はROUND関数。
=ROUND(A1,0) → 整数に
=ROUNDDOWN(A1,0) → 切り捨て
=ROUNDUP(A1,0) → 切り上げ
表示形式で桁を減らしても、中身は元の数値のままです。計算に使う値は関数で丸めましょう。
#Excel #ROUND #関数 #業務効率化
=ROUND(A1,0) → 整数に
=ROUNDDOWN(A1,0) → 切り捨て
=ROUNDUP(A1,0) → 切り上げ
表示形式で桁を減らしても、中身は元の数値のままです。計算に使う値は関数で丸めましょう。
#Excel #ROUND #関数 #業務効率化
September 2, 2026 at 3:01 AM
Excelの四捨五入はROUND関数。
=ROUND(A1,0) → 整数に
=ROUNDDOWN(A1,0) → 切り捨て
=ROUNDUP(A1,0) → 切り上げ
表示形式で桁を減らしても、中身は元の数値のままです。計算に使う値は関数で丸めましょう。
#Excel #ROUND #関数 #業務効率化
=ROUND(A1,0) → 整数に
=ROUNDDOWN(A1,0) → 切り捨て
=ROUNDUP(A1,0) → 切り上げ
表示形式で桁を減らしても、中身は元の数値のままです。計算に使う値は関数で丸めましょう。
#Excel #ROUND #関数 #業務効率化
아...
=ifelse(rounddown(C1)>=24,24,rounddown(C1))
이러면 되나
=ifelse(rounddown(C1)>=24,24,rounddown(C1))
이러면 되나
July 9, 2026 at 11:12 AM
아...
=ifelse(rounddown(C1)>=24,24,rounddown(C1))
이러면 되나
=ifelse(rounddown(C1)>=24,24,rounddown(C1))
이러면 되나
March 13th 1945 - KD578a awaits recovery after it hit the rounddown on landing, ripping off the tail oleo. The aircraft crashed through Nos. 2 & 3 barriers before coming to rest on its nose, facing aft.
#UK, via: www.royalnavyresearcharchive.org.uk/SQUADRONS/Ga...
#UK, via: www.royalnavyresearcharchive.org.uk/SQUADRONS/Ga...
July 3, 2026 at 1:54 PM
March 13th 1945 - KD578a awaits recovery after it hit the rounddown on landing, ripping off the tail oleo. The aircraft crashed through Nos. 2 & 3 barriers before coming to rest on its nose, facing aft.
#UK, via: www.royalnavyresearcharchive.org.uk/SQUADRONS/Ga...
#UK, via: www.royalnavyresearcharchive.org.uk/SQUADRONS/Ga...
#roundup #rounddownyougreedybastards - #roundDOWN YOU GREEDY BASTARDS BUT YEAH INFLATION AND TARIFFS. Now you’re STEALING OUR CHANGE. Taking our money in front of our faces. Get ready bruh.
January 3, 2026 at 5:08 AM
#roundup #rounddownyougreedybastards - #roundDOWN YOU GREEDY BASTARDS BUT YEAH INFLATION AND TARIFFS. Now you’re STEALING OUR CHANGE. Taking our money in front of our faces. Get ready bruh.
=ROUND(셀주소,숫자)
숫자만큼 소숫점 자리를 반올림해준다
=ROUNDUP(셀주소,숫자)
숫자만큼 소숫점 자리를 올림
=ROUNDDOWN(셀주소,숫자)
숫자만큼 소숫점 자리를 내림
=LEN(텍스트)
텍스트의 개수를 구할 때 사용하는 함수
=TEXT(인수,형식)
숫자를 문자로 바꿀 때 활용하는 함수.
=REPLACE(텍스트1,시작위치,개수,테스트2)
특정 텍스트(텍스트1)를 다른 텍스트(텍스트2)로 바꾸는 함수.
시작 위치와 갯수 지정이 MID와 유사.
숫자만큼 소숫점 자리를 반올림해준다
=ROUNDUP(셀주소,숫자)
숫자만큼 소숫점 자리를 올림
=ROUNDDOWN(셀주소,숫자)
숫자만큼 소숫점 자리를 내림
=LEN(텍스트)
텍스트의 개수를 구할 때 사용하는 함수
=TEXT(인수,형식)
숫자를 문자로 바꿀 때 활용하는 함수.
=REPLACE(텍스트1,시작위치,개수,테스트2)
특정 텍스트(텍스트1)를 다른 텍스트(텍스트2)로 바꾸는 함수.
시작 위치와 갯수 지정이 MID와 유사.
January 7, 2025 at 7:30 AM
=ROUND(셀주소,숫자)
숫자만큼 소숫점 자리를 반올림해준다
=ROUNDUP(셀주소,숫자)
숫자만큼 소숫점 자리를 올림
=ROUNDDOWN(셀주소,숫자)
숫자만큼 소숫점 자리를 내림
=LEN(텍스트)
텍스트의 개수를 구할 때 사용하는 함수
=TEXT(인수,형식)
숫자를 문자로 바꿀 때 활용하는 함수.
=REPLACE(텍스트1,시작위치,개수,테스트2)
특정 텍스트(텍스트1)를 다른 텍스트(텍스트2)로 바꾸는 함수.
시작 위치와 갯수 지정이 MID와 유사.
숫자만큼 소숫점 자리를 반올림해준다
=ROUNDUP(셀주소,숫자)
숫자만큼 소숫점 자리를 올림
=ROUNDDOWN(셀주소,숫자)
숫자만큼 소숫점 자리를 내림
=LEN(텍스트)
텍스트의 개수를 구할 때 사용하는 함수
=TEXT(인수,형식)
숫자를 문자로 바꿀 때 활용하는 함수.
=REPLACE(텍스트1,시작위치,개수,테스트2)
특정 텍스트(텍스트1)를 다른 텍스트(텍스트2)로 바꾸는 함수.
시작 위치와 갯수 지정이 MID와 유사.
ROUNDUP=move away from zero
ROUNDDOWN=move toward zero (become integer via truncation)
CEILING=move toward +∞ (closest integer >= x)
FLOOR=move toward -∞ (closest integer <= x)
ROUNDDOWN=move toward zero (become integer via truncation)
CEILING=move toward +∞ (closest integer >= x)
FLOOR=move toward -∞ (closest integer <= x)
November 11, 2025 at 1:41 AM
ROUNDUP=move away from zero
ROUNDDOWN=move toward zero (become integer via truncation)
CEILING=move toward +∞ (closest integer >= x)
FLOOR=move toward -∞ (closest integer <= x)
ROUNDDOWN=move toward zero (become integer via truncation)
CEILING=move toward +∞ (closest integer >= x)
FLOOR=move toward -∞ (closest integer <= x)
💡 Summary by GPT:
この文章は、経理や事務の現場で実務に役立つExcelの小技を5つ紹介しています。具体的には、月末日を自動取得するEOMONTH関数、偶数・奇数月の処理を自動化するMODとIFの組み合わせ、非表示行の集計ミスを防ぐSUBTOTALの比較、数式の適用漏れを検知する要素数チェック、小数点以下の誤入力を厳密に検出するROUNDUPとROUNDDOWNの比較などです。これらの小技は、ミス防止や作業効率化に役立ち、日常業務の不安ポイントを減らすことを目的としています。
この文章は、経理や事務の現場で実務に役立つExcelの小技を5つ紹介しています。具体的には、月末日を自動取得するEOMONTH関数、偶数・奇数月の処理を自動化するMODとIFの組み合わせ、非表示行の集計ミスを防ぐSUBTOTALの比較、数式の適用漏れを検知する要素数チェック、小数点以下の誤入力を厳密に検出するROUNDUPとROUNDDOWNの比較などです。これらの小技は、ミス防止や作業効率化に役立ち、日常業務の不安ポイントを減らすことを目的としています。
January 25, 2026 at 11:04 PM
💡 Summary by GPT:
この文章は、経理や事務の現場で実務に役立つExcelの小技を5つ紹介しています。具体的には、月末日を自動取得するEOMONTH関数、偶数・奇数月の処理を自動化するMODとIFの組み合わせ、非表示行の集計ミスを防ぐSUBTOTALの比較、数式の適用漏れを検知する要素数チェック、小数点以下の誤入力を厳密に検出するROUNDUPとROUNDDOWNの比較などです。これらの小技は、ミス防止や作業効率化に役立ち、日常業務の不安ポイントを減らすことを目的としています。
この文章は、経理や事務の現場で実務に役立つExcelの小技を5つ紹介しています。具体的には、月末日を自動取得するEOMONTH関数、偶数・奇数月の処理を自動化するMODとIFの組み合わせ、非表示行の集計ミスを防ぐSUBTOTALの比較、数式の適用漏れを検知する要素数チェック、小数点以下の誤入力を厳密に検出するROUNDUPとROUNDDOWNの比較などです。これらの小技は、ミス防止や作業効率化に役立ち、日常業務の不安ポイントを減らすことを目的としています。