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 189 views

## What are the main reason why python is becoming more popular as compared top R or Java with regards to Data Science?

First of all, Java is not used ...READ MORE

## Why bucket policy does not provide IAM user to list s3 buckets even bucket policy is set for the user?

I have created bucket POC-work from the ...READ MORE

## Excel VLOOKUP where the key is not in the first column

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

## 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

## 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

## 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

## Excel feet and inches to millimeters

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

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

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