Results 1 to 6 of 6

Calculate dollar amount paid if between a to and from amount

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2006
    Location
    WV
    MS-Off Ver
    2003,2007,2010
    Posts
    79

    Calculate dollar amount paid if between a to and from amount

    Hello, I have a chart that has in dollar amounts a "Wages in base period" Starting in row C and ending in row E and if your within that range then it would display the "Weekly benefit rate" OR if below $2,200.00 it would display the words "INELIGIBLE" both in (Cell I5). The number that would be entered to see what rate you would get would be in (I4) How would I do this?

    Example:

    If I entered $5,500.00 into I4
    it would display $58.00 in I5

    Example 2:

    If I entered $2,100.00 in I4
    it would display INELIGABLE in I5
    Attached Files Attached Files
    Last edited by oxicottin; 11-21-2012 at 08:01 PM. Reason: solved

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