New Posts For Thread: Excel help - multiple IF query in one cellhttps://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cellHelloI'm trying to do the following in one cell for recording a result, is it possible or do I have to break it down into three cells and record the result in another cell.=IF((K2L2,1,"")(IF(K2L2,2,"")(if(k2=l2,3,""))there's a fault in the above, butCheers to you both.I didn't realise my original post missed out the Greater Than sign etc.That's done the trick.https://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cell?post_id=419158774#419158774Cheers to you both.I didn't realise my original post missed out the Greater Than sign etc.That's done the trick.Sat, 28 Nov 2009 02:21:57 -0600You could leave out the "" at the end as it isn't necessary.https://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cell?post_id=419158770#419158770You could leave out the "" at the end as it isn't necessary.Sat, 28 Nov 2009 02:20:22 -0600=IF(K2L2,1,IF(K2L2,2,IF(K2=L2,3,"")))Where it is K2(greaterthan)L2 and then K"(less than)L2. Assuming that is what you are trying to dohttps://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cell?post_id=419158766#419158766=IF(K2L2,1,IF(K2L2,2,IF(K2=L2,3,"")))Where it is K2(greaterthan)L2 and then K"(less than)L2. Assuming that is what you are trying to doSat, 28 Nov 2009 02:17:47 -0600It's a bit hard to see what you're trying to do, can you just describe in words what you want this bit of the formula to do:=IF(K2L2,1,"")https://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cell?post_id=419158762#419158762It's a bit hard to see what you're trying to do, can you just describe in words what you want this bit of the formula to do:=IF(K2L2,1,"")Sat, 28 Nov 2009 02:05:47 -0600HelloI'm trying to do the following in one cell for recording a result, is it possible or do I have to break it down into three cells and record the result in another cell.=IF((K2L2,1,"")(IF(K2L2,2,"")(if(k2=l2,3,""))there's a fault in the above, buthttps://community.betfair.com/general_betting/go/thread/view/94082/23469574/excel-help---multiple-if-query-in-one-cell?post_id=419158758#419158758HelloI'm trying to do the following in one cell for recording a result, is it possible or do I have to break it down into three cells and record the result in another cell.=IF((K2L2,1,"")(IF(K2L2,2,"")(if(k2=l2,3,""))there's a fault in the above, butSat, 28 Nov 2009 01:44:00 -0600