Results 1 to 4 of 4

Combination of IF and ISERROR problem

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2009
    Location
    pasig
    MS-Off Ver
    Excel 2003
    Posts
    4

    Combination of IF and ISERROR problem

    Hi,

    I need to create a formula that will check a specific character in a column and return a value and if there is none it will try to check another column for a different sets of conditions.

    Here is the sample formula that I have done so far it returns the values and false.

    A - That has a % in the cell will return "Discounted Term"
    B - Other.

    =IF(ISERR(SEARCH("%",M2324)),IF(N2324=0,"Pay on Receipt",IF(N2324<=30,"1 to 30 Days",IF(N2324<=49,"31 to 49 Days",IF(N2324<=79,"50 to 79 Days",IF(N2324<=90,"80 to 90 Days",IF(N2324>90,"91+ Days","Discounted Term")))))))
    Attached Files Attached Files
    Last edited by cool_freeze; 02-08-2009 at 10:28 PM. Reason: Changed title

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