Formulas for Golden Ratio
I am looking for Golden Ratio formulas. Google searches only provide width from known height or height from known width.
Instead, what I want to calculate is:
- width from known area
- height from known area
(For more information on Golden Ratio, try google or the websites below:
http://elliotwaite.com/golden-ratio-calculator/
http://www.mathsisfun.com/numbers/golden-ratio.html
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Hopefully this is right.
For width from a known area use:
=SQRT(A1*((1+SQRT(5))/2)^3)/((1+SQRT(5))/2), where A1 is the known area
For height from a know area use:
=SQRT(A1*((1+SQRT(5))/2)^3)/((1+SQRT(5))/2)^2
I have used (1+Sqrt(5))/2 to calculate phi, if you have the value in a cell elsewhere you may want to substitute it out
Thanks Nigel +1
1. W/H = 1.618
2. W = 1.618 H
3. A = W * H
Therefore, A = 1.618H2
& H = SQRT(A/1.618),
& W = SQRT(1.618 * A)
Ben Van Johnson
... or you could not over complicate it like me and use protonLeah's formula...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks