+ Reply to Thread
Results 1 to 5 of 5

IFERROR help -

Hybrid View

adamjohnson182 IFERROR help - 04-05-2013, 06:15 PM
Tank997 Re: IFERROR help - 04-05-2013, 06:31 PM
adamjohnson182 Re: IFERROR help - 04-05-2013, 06:33 PM
ragavan.sridar1 Re: IFERROR help - 04-05-2013, 06:40 PM
Tony Valko Re: IFERROR help - 04-05-2013, 06:47 PM
  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    IFERROR help -

    So, I have values in cell F2, and I want G2 to return the value in F2 but cap the returned value at 10, and also if there is an error in cell F2, I need the returned value to be 0.

    I tried =IFERROR((IF(F2>10,10,F2)),0) but that just returns "FALSE" no matter the value in F2.

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: IFERROR help -

    get rid of the extra set of parenthesis and try =IFERROR(IF(F2>10,10,F2),0)
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  3. #3
    Registered User
    Join Date
    10-19-2010
    Location
    Arlington, WA
    MS-Off Ver
    Excel 2013
    Posts
    40

    Re: IFERROR help -

    Perfect. Thanks!

  4. #4
    Forum Contributor ragavan.sridar1's Avatar
    Join Date
    11-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010, Excel 2003
    Posts
    208

    Re: IFERROR help -

    This works fine for me.

    =IFERROR(IF(F2>10, 10, F2), 0)
    Thanks!
    Raga.

    Please,mark your thread [SOLVED] if you received your answer.

    Click the little star * below, to give some Rep if you think an answer deserves it.

    I learnt so many things from these links.

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: IFERROR help -

    Here's another one...

    =IFERROR(MIN(10,F2),0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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