I have been able to next IF functions but am having trouble including what I think needs to be a nested AND function. I have attached a worksheet...I need the value in column C to be based on data in columns A and B. But in the table that determines the ranges, getting a formula for the range of 1000-1500 is giving me trouble because it seems like it should be a nested AND function. But it doesn't work. Any help would be great! Thanks!
Okay, help me out. What and how is the table H:O trying to do? I don't see any numbers between 1000 and 1500 or any percentages anywhere.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ok sorry. I'm new here and must not have attached the file correctly.Originally Posted by ChemistB
I have a column of percentages and a column of net totals. Then I have a table of ranges that uses those columns to determine a value. For example, if percentage in column A is less than 50% and the net total in column B is between 1000 and 1500, then I need a certain value returned to column C.
Try this attachment...thanks!
Yes, I think you attached the wrong file.
In your specific example, let's say we're in C2
= IF(AND(A2<50%, B2>=1000, B2<=1500), Certain Value, Other value)
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks