Results 1 to 9 of 9

Function to return MAX value for a range

Threaded View

  1. #1
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Function to return MAX value for a range

    I can't get my brain around which function to use use to return the largest number in a range of cells(E2:CA2) and show the result in CG2.

    I thought about IF and MAX functions, but I'm unsure if I'm even using them correctly or not. I'm tired of wasting hours on this simple problem and need some help.

    I've attached a worksheet so you can see what I'm up against.

    The employees earn a cash bonus for every 30 days of working safely or not having a safety violation ($25 for 30 days, $30 for 60 days, $35 for 90 days, and $40max for 120 days or more)

    BTW, The employee names and clock numbers are linked to another workbook so if they don't show up for you that is why.
    Attached Files Attached Files
    Last edited by jwright650; 02-08-2011 at 11:14 AM. Reason: Solved with correct data type
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

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