I need to get the aspect ratio of an image from the dimensions provided.
There are a couple of obvious solutions that come to mind, but I have no idea if excel can implement them.
One requires control flow and the other - a rationalization function.
As I haven't been able to find any of these(beyond a simple IF), I'm stuck.
How about just dividing width by height?
Entia non sunt multiplicanda sine necessitate
What I meant is - get results in the form of ex. 16/9 or 4/3, basically RATIONALIZE it.
Like this?
Please Login or Register to view this content.
Yup.
Started trying to do it in VB, but being completely new I need to understand the syntax first before I can produce anything functional.
The formula in C1 and down is =A1/B1, and the result is formatted as ??/??
LolOk.
Added a little high school math and it all worked perfectly.
Last edited by martix; 01-05-2011 at 09:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks