Calculate dollar amount paid if between a to and from amount

**alansidman** · 11-21-2012, 07:34 PM

Try this:

=VLOOKUP(I4,$C$5:$G$259,4,TRUE)

**oxicottin** · 11-21-2012, 07:46 PM

This works but to a point, If I enter below the 2,200.00 it should display "INELIGABLE" instead it shows #N/A and if the cell I4 is empty then it also shows a #N/A and it will always start out empty. How can I incorporate? Thanks!

Calculate dollar amount paid if between a to and from amount

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Calculate dollar amount paid if between a to and from amount

Re: Calculate dollar amount paid if between a to and from amount

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions