| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IFs
I need to display the result of multiple IFs
if (J110<25) "1", if (j125<50), "2", if (j150), "3"- Driving me mad...anybody help please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IFs
Try
=IF(AND(J110,J1<25),"1",IF(AND(J125,J1<50),"2",I F(J150,"3")) I "WannaM" wrote in message ... I need to display the result of multiple IFs if (J110<25) "1", if (j125<50), "2", if (j150), "3"- Driving me mad...anybody help please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IFs
=IF(AND(J110;J1<25);1;IF(AND(J125;J1<50);2;IF(J1 50;3;"")))
"WannaM" skrev: I need to display the result of multiple IFs if (J110<25) "1", if (j125<50), "2", if (j150), "3"- Driving me mad...anybody help please? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IFs
ups
=IF(AND(J110,J1<25),1,IF(AND(J125,J1<50),2,IF(J1 50;3,""))) "excelent" skrev: =IF(AND(J110;J1<25);1;IF(AND(J125;J1<50);2;IF(J1 50;3;""))) "WannaM" skrev: I need to display the result of multiple IFs if (J110<25) "1", if (j125<50), "2", if (j150), "3"- Driving me mad...anybody help please? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple IFs
Hi
In addition to the solutions you have, it could be achieved without IF statements, provided you can accept 0 as the result if the value in A1 does not match any of the criteria =(INT((A1-1)/25)+1)-(A1<10) -- Regards Roger Govier "WannaM" wrote in message ... I need to display the result of multiple IFs if (J110<25) "1", if (j125<50), "2", if (j150), "3"- Driving me mad...anybody help please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
| External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Linear Mode
