bernie_carlton
Lifetime Supporting Member + Moderator
This is how I set up a spreadsheet in column A. Enter values in A1, A2, A3
21.3 (The value of the diagonal)
16 (The width of the aspect ratio)
9 (The height of the aspect ratio)
=A1/SQRT((A2*A2)+(A3*A3))
= A2*A4 (Width)
=A3*A4 (Height)