Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Sum of divide – Array formula Array formula
  • Unix DateTime Number Basic Math
  • Count Unique COUNTIF
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Search across sheets in function ADDRESS
  • Custom fiscal year calendar (CFlex) Basic Math
  • New function IFERROR, finally IFERROR
  • Shapes with dynamic output Excel User tips

Standard math to calculate Aspect Ratio

Posted on January 24, 2012 By ANmar No Comments on Standard math to calculate Aspect Ratio

Here is a simple formula that uses standard math functions (+ , – , / and *) to calculate the aspect ratio

I often need some simple formula like this to get image dimensions

Two formulas used here, one in C9:

=F9*C3/F3

And another one in cell F7:

=C6*F3/C3

Basic Math, Standard functions

Post navigation

Previous Post: MID + SEARCH to convert cell to rows
Next Post: Sum of divide – Array formula

Related Posts

  • Cells with additional spaces AND
  • MID + SEARCH to convert cell to rows MID
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Multiple lines in cell using functions CHAR
  • Insert Blank rows into table using functions CHAR
  • Return 12 values in one number AND

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • iframe in Excel (XLiFrame) ADDRESS
  • Repeated Offset Basic Math
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Always get 1st name (or last) Formulas - combined functions
  • 6174 Kaprekar’s constant Basic Math
  • The Excel “&” bug Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme