Results 1 to 11 of 11

Multiple IF’s with ISERROR

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    475

    Question Multiple IF’s with ISERROR

    Hi,

    I currently use the following formula using IF and ISERROR i.e.

    =IF(ISERROR(IF(O12-(O12/100*80)<S12,"",IF(O12="","","Warning 20% or less Cover Remains!")))," ",(IF(O12-(O12/100*80)<S12,"",IF(O12="","","Warning 20% or less Cover Remains!"))))

    What I’m after is to add an addition condition e.g. using “IF(O12-(O12/100*80)<S12” and “IF(O12-(O12/100*90)<S12” which would display either Warning 20% or less Cover Remains! or Warning 10% or less Cover Remains! incorporating ISERROR to avoid #N/A

    Any help would be greatly appreciated

    Many thanks

    Rob

    Excel version 2003
    Last edited by robertguy; 11-11-2009 at 04:08 PM. Reason: To mark [SOLVED]
    Rob

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