+ Reply to Thread
Results 1 to 3 of 3

Thread: IF function help?

  1. 11-18-2011, 04:58 PM #1
    BobbumMan
    BobbumMan is offline
    Registered User
    Join Date
    11-18-2011
    Location
    California, United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    IF function help?

    I need a function that will do the following:

    If G6>=75, then I need the cell to say "MAX". But if false, or G6<75, then I need the cell to show the actual value or number in G6.

    I tried IF(G6>=75,"MAX","G6"), but it did not work. What am I doing wrong?

    Help?
    Reply With Quote Reply With Quote
  2. 11-18-2011, 05:05 PM #2
    tom1977
    tom1977 is offline
    Valued Forum Contributor
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    895

    Re: IF function help?

    maybe this way

    IF(G6>=75,"MAX",G6)
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.
    Reply With Quote Reply With Quote
  3. 11-18-2011, 05:06 PM #3
    Paul
    Paul is offline
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,953

    Re: IF function help?

    Hi Bobbum Man, welcome to the forum.

    You just need to remove G6 from the quotes. Within quotes, it's considered a text string. Outside of the quotes it is a cell reference. So...

    =IF(G6>=75,"MAX",G6)
    - Paul

    Click here to read the Forum Rules

    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0