I'm trying to populate one cell based on 4 ranges in values... so..
If A1 is between 0 and 349,999, then B1
OR If A1 is between 350,000 and 749,999, then B2
OR If A1 is between 750,000 and 1,149,999 then B3
OR If A1 is greater than 1,150,000, then B4
Is there a way to combine these all into one formula? I feel like it's an easy job, but my mind is just blanking...
=if(a1<=0,"",if(a1<35,b1,if(a1<75,b2,if(a1<115,b3,b4))))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks