| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With If And Or
Hi need help with the following I've a cell with a value of between 3 & 11, I need to see if that cell meets a criteria to rate accordingly. between 3 & 5 = 8 points between 6 & 10 = 9 points 11+ = 10 points Rik  -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
Hi Rik, Try this: =IF(K9<3,"what should this be, zero?",IF(AND(3<=K9,K9<=5),8,IF(AND(6<=K9,K9<=10), 9,10))) where K9 is the cell you want to check. hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
Thank You work perfectly. Rik:) -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
glad to help
-- Don Guillett SalesAid Software "Rikuk" wrote in message ... Thank You work perfectly. Rik:) -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
Looks good, Don, Much tidier than my version - I just need to adjust my way of working to the solution. I think I went at this one a bit too literally. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
using this, best to work from the highest figure down
-- Don Guillett SalesAid Software "broro183" wrote in message ... Looks good, Don, Much tidier than my version - I just need to adjust my way of working to the solution. I think I went at this one a bit too literally. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
Another option assuming only numbers in A1. I'm not sure about numbers like
5.5 & 10.5. :o =8*(A13)+(A15)+(A110) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Rikuk" wrote in message ... Hi need help with the following I've a cell with a value of between 3 & 11, I need to see if that cell meets a criteria to rate accordingly. between 3 & 5 = 8 points between 6 & 10 = 9 points 11+ = 10 points Rik -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With If And Or
hi,
try this. I put 3 in A5, 7 in A6 and 12 in A7. this forumla produced 8 in B5, 9 in B6, 10 in B7 and nothing in B8. =IF(AND(A7=3,A7<=5),8,IF(AND(A7=6,A7<=10),9,IF(A 7=11,10,""))) if the cell contains nothing, the formula displays nothing so if you want it to display something like a zero then change the double quotes to a zero or put text between the quotes. Regards, FSt1 "Rikuk" wrote: Hi need help with the following I've a cell with a value of between 3 & 11, I need to see if that cell meets a criteria to rate accordingly. between 3 & 5 = 8 points between 6 & 10 = 9 points 11+ = 10 points Rik -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526266 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
