• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Detailed guide on how to use the BASE function in Excel

0 Comments

Detailed guide on how to use the BASE function in Excel: The BASE function is one of the commonly used mathematical and trigonometric functions in Excel. The Excel Base function converts a number into a supplied base (radix) and returns a text representation of the calculated value.

1. BASE function structure

Function syntax: =BASE(number; radix; [min_length])
Where:

  • number: Required argument, the number you want to convert to text. Number must be an integer and 0 ≤ number < 2 to the power of 53.
  • radix: Required argument, the base you want to convert to. Radix must be an integer and 2 ≤ radix ≤ 36.
  • min_length: Optional argument, the minimum length of the returned text string. Min_length must be an integer and greater than or equal to 0.

Note:

  • If number is not a numeric value, the BASE function returns the error value #VALUE!
  • If number, radix, min_length are outside the maximum and minimum limits, the BASE function returns the error value #NUM!
  • The maximum value of the min_length argument is 255.
  • Any non-integer value will be truncated to an integer or the function will take the integer part of those values.
  • If the returned value of the function is shorter than the specified minimum length, the function will add to the result if it is 0.

2. How to use the BASE function

For example, suppose you want to convert numbers as follows:

  • Convert the number 35 to base 4
  • Convert the number 35.5 to base 4
  • Convert the number 35.5 to base 4, with a minimum length of 5
  • Convert the number 61 to base 12
  • Convert the number 61.2368 to base 12
  • Convert the number 61 to base 12, with a minimum length of 9
  • Convert the number 113 to base 24
  • Convert the number 113.27 to base 24
  • Convert the number 113.27 to base 24, with a minimum length of 16

Using the function structure above, we have the conversion formula for the cases as follows:

Detailed guide on how to use the BASE function in Excel

Detailed guide on how to use the BASE function in Excel

  • Convert the number 35 to base 4: =BASE(35;4)
  • Convert the number 35.5 to base 4: =BASE(35.5;4)
  • Convert the number 35.5 to base 4, with a minimum length of 5: =BASE(35.5;4;5)
  • Convert the number 61 to base 12: =BASE(61;12)
  • Convert the number 61.2368 to base 12: =BASE(61.2368;12)
  • Convert the number 61 to base 12, with a minimum length of 9: =BASE(61;12;9)
  • Convert the number 113 to base 24: =BASE(113;24)
  • Convert the number 113.27 to base 24: =BASE(113.27;24)
  • Convert the number 113.27 to base 24, with a minimum length of 16: =BASE(113.27;24;16)

The results we obtain are shown in the figure below:

Detailed guide on how to use the BASE function in Excel

Detailed guide on how to use the BASE function in Excel

Therefore, the above article has guided you on how to use the BASE function in Excel. Good luck!

Rate this post
20
231 Views
Using the DATE function and combining with other functions in ExcelPrevUsing the DATE function and combining with other functions in ExcelMay 9, 2023
How to vertically type in ExcelMay 9, 2023How to vertically type in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
Products
  • Windows Server 2019 Essentials Key Global Windows Server 2019 Essentials Key Global
    Rated 4.71 out of 5
    $7.00
  • Windows 10 Pro OEM Key Global - Reinstalling win is still active Windows 10 Pro OEM Key Global - Reinstalling win is still active
    Rated 4.88 out of 5
    $6.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • microsoft office home and business 2019 pcmac key Microsoft Office Home And Business 2019 (MAC) key bind to your Microsoft account
    Rated 4.95 out of 5
    $30.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Avast SecureLine VPN 2021 1 Year 5 Devices Global Avast SecureLine VPN 2021 1 Year 5 Devices Global
    Rated 4.91 out of 5
    $34.00
  • Windows Server 2012 R2 Standard Key Global Windows Server 2012 R2 Standard Key Global
    Rated 4.78 out of 5
    $15.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • Kaspersky Plus - 1 Device 1 Year - GLOBAL Kaspersky Plus - 1 Device 1 Year - GLOBAL $23.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.