Results 1 to 6 of 6

Formula to solve multiple scenarios with one general outcome

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2006
    Posts
    19

    Exclamation Formula to solve multiple scenarios with one general outcome

    I have an excel spread sheet where I need multiple outcomes for different scenarios.
    I need to have the Disc to display a value based on 2 rows
    example if e2=RRS then J2=50 but if e2 is blank I need the value to be based on the number of years
    1-5 years 50
    6-10 years 100
    11-15 years 150
    20+years 200

    I was able to put the "if" formula for the first scenario but got stuck after that I tried an array formula still could not get what I wanted.
    Please help
    Attached Files Attached Files

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