# formulas for squares, trines, quads

#### zebra7860

##### Active Member
Hello,

Does anybody have the Excel formulas on how to get SQUARES, TRINES( to power of 3 ) and QUADS ( power of 4 )?

I have a column of numbers and wanted to construct 3 additional columns that give me these results. So, for example, if the first column has numbers 1 to 22. The next column would be for the squares. If we wanted the square of 3, we know that this would be 3 to the raised power of 2, which is the same as 3x3 = 9. The trine would have been 3 to the raised power of 3, quad would be 3 to the raised power of 3,etc.

Any help would be appreciated,
Al

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Square: =A1^2

Trine: =A1^3

#### zebra7860

##### Active Member
Much appreciated, sir!

Al

Replies
3
Views
102
Replies
3
Views
106
Replies
3
Views
245
Replies
3
Views
367
Replies
1
Views
139

1,196,019
Messages
6,012,900
Members
441,738
Latest member
dataexcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back