Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Expenses calendar, FaCal Basic Math
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Filter. Google Sheets function Google Sheets
  • Fixed length ID Formulas - combined functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Hello world! Uncategorized
  • MATCH fumction, just a simple search Lookup and References
  • Blank (isempty) VS “” (null string) 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

  • Links between two workbooks – dynamically using functions INDIRECT
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • CamelCase to Camel Case CHAR
  • Sorting with functions only CHOOSE
  • Searching table in 2 dimensions. Formulas - combined functions
  • BMI Calculator Basic Math

Leave a Reply Cancel reply

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

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Cells with additional spaces AND
  • New function IFERROR, finally IFERROR
  • VALUE() of LEFT() Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • MID + SEARCH to convert cell to rows MID
  • Paste Special Percentage Excel User tips
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Sum of divide – Array formula Array formula

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme