I need one formula that will return the value of $750, $1000 or $0 depending on the value range of another cell.
Ex... If the value of cell A1 is less than 5000 then return "$1000, if cell A1 is between the range of 5001 and 7000 then return $750, If cell A1 is more than 7001 then return $0.
=lookup(a1,{"",0,5000,5,7000},{1000,1000,750,0})
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
or may be
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks