+ Reply to Thread
Results 1 to 2 of 2

Finding the max with division

  1. #1
    Registered User
    Join Date
    08-04-2012
    Location
    Texas, USA
    MS-Off Ver
    Excel 2003
    Posts
    8

    Finding the max with division

    Hello I am not good with formulas in excel....and I was wondering if this was possible.

    =MAX(N74/T76)MAX (N73/S76) MAX(N72/R76) MAX(N71/Q76) MAX(N70/P77)

    I tried with only the max at the front and I still got the same parse error.

    Any help is much appreciated.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Finding the max with division

    Are you trying to find out the maximum amongst these 5 calculations?
    N74/T76 , N73/S76 , N72/R76 , N71/Q76 , N70/P77

    Try..
    =MAX(N74/T76,N73/S76,N72/R76,N71/Q76,N70/P77)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1