Excel formula...

[rivan]

So it's been too many years since high school, and the twice a year I use Excel hasn't kept me all that sharp in solving and writing equations.

After a discussion with a coworker, I decided to try to make a little spreadsheet that would find the height and width of a both normal and widescreen TV screens of a given advertized (diagonal) size.

Pretty simple, right... it's solving for a^2+b^2 when you know c^2 and the ratio of a:b, but I just can't wrap my head around how to phrase it for Excel.

Duh...help?

 

[Howard]

Given the viewable (not the tube) dimensions?

For a 4:3 tube, this should do it

height = 3*((S^2)/25)^0.5
width = 4*((S^2)/25)^0.5

16:9

height = 9*((S^2)/337)^0.5
width = 16*((S^2)/337)^0.5

where S is the nominal size, put the value in a cell and replace S with the cell address

 

[rivan]

Thanks =)