Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

cubic root formula in excel 5

Status
Not open for further replies.
conveyorbud

conveyorbud

Mechanical
Joined
Apr 23, 2004
Messages
21
Location
US
what is the formula for finding the cubic root in excel
eg: cell f12= 38.193 and i need the f13 cell to = 3.367
 
Sort by date Sort by votes
Hi,
Please enter in in the f13 cell as follows
=f12^(1/3)
You will get the answer.
KMP
 
Upvote 0 Downvote
The answer is valid for all the "roots" you want.

Square root:
=f12^(1/2)

Cubic root:
=f12^(1/3)

N root:
=f12^(1/n)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kenja824
  • Locked
  • Question Question
excel Formula Find help
Replies
5
Views
1K
Kenja824
Kenja824
Kenja824_home
  • Locked
  • Question Question
Excel - Looking for a formula please
Replies
14
Views
1K
BridgeSmith
BridgeSmith
BhagyeshVashi
  • Locked
  • Question Question
Need a rename macro for excel
Replies
11
Views
2K
sdz
sdz
Kenja824
  • Locked
  • Question Question
New Formula Help
Replies
3
Views
879
SkipVought
SkipVought
Kenja824
  • Locked
  • Question Question
Formula help please
Replies
11
Views
1K
SkipVought
SkipVought

Part and Inventory Search

Sponsor

Back
Top