Why is Excel not calculating the cube root as the cube root

0 votes

I think Excel treats exponents with recurring decimals written as fractions (like 1/3) differently than exponents without repeating decimals (like 1/2). It keeps me from using a formula that locates perfect cubes among a set of numbers.

Column A lists numbers 1 to 100.

Column B has the following formula (starting with row 5):

=IF($A5^(1/2)-ROUND($A5^(1/2),0)=0,1,0)

If the integer in column A is a perfect square, such as 1, 4, or 9, and does so correctly, this should return "1." The second formula I came up with, =IF(SQRT($A8)-ROUND(SQRT($A8),0)=0,1,0), also works.

Column C has the following formula (starting with row 5):

=IF($A5^(1/3)-ROUND($A5^(1/3),0)=0,1,0)

The only difference between this formula and the one for recognizing perfect squares is that there is a 3 where there was previously a 2. In the case of perfect cubes like 8, 27, 64, etc., this is not yielding a "1." (but does return a "1" for the number 1).
Can somebody correct this for me?

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
333 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

Excel VLOOKUP where the key is not in the first column

INDEX/MATCH will do it in any direction of ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 63,600 points
1,469 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,600 points
892 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,600 points
1,450 views
0 votes
1 answer

Can an Excel xll function indicate that the return value should be displayed as a date and not a number?

To my knowledge, the only method to ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,600 points
952 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,825 views
0 votes
1 answer

Formula to calculate chance (probability) of a dice side based on its value

If I understand you correctly, you're looking ...READ MORE

answered Mar 17, 2022 in Machine Learning by Dev
• 6,000 points
769 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,600 points
787 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,600 points
851 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP