Aspect Ratio in Numbers '09

BJP,

Would you settle for "1.5:1" in this case?

Jerry

aspect ratio is the ratio of the larger number to another generally scaled so that the bottom number is a whole (or integer) number.

Here is one way you can do this. I am presenting in one table for convenience of demonstration only:

C3 contains the width

C4 contains the height

C5 is the ratio of W/H

C5=C3/C4

D5 thru P5 contain multiples of this ratio starting at one (1)

D5=$C$5*(COLUMN()-3)

select D5 and fill to the right as far as you like (I went to column Q)

D4=IF(INT((COLUMN()-3)*$C$5)=D5,(COLUMN()-3), "")

select D4 and fill to the right to the same column as the previous step

C7=MIN(D4:Q4)

C8=HLOOKUP(C7,D4:Q5, 2)&":"&C7

Try this.

Pixel counts in columns B2 and C2, formula in D2

D2: =B2/GCD(B2,C2)&":"&C2/GCD(B2,C2)

Filled down.

Result is a text string. Full (Letter and number) cell reference required, as GCD will accept range arguments.

Error triangles are division by zero errors.

Formula in E2 is the workhorse in the one above: =GCD(B2,C2)

Regards,

Barry

Barry,

That's a very good solution. I didn't get that far. I was hung up on "pixel height in one column, pixel width in another". Did the OP really mean pixel count rather than pixel height/width? Height and width are only rough indications of final aspect ratio, similarly for pixel count if the shape of the pixels is unknown. The pixel pitch is the more meaningful measurement.

In either case, if it's a measurement, and since measurements vary from the truth, we're unlikely to get a measure that will give us a clean 3:2 aspect ratio even if that was the designer's intent.

Jerry