New Posts For Thread: excel help.https://community.betfair.com/general_betting/go/thread/view/94082/23482366/excel-helpI'm trying to do the following =if(e2=b1,if(c2 islessthan d2,1,0)) but as I understand it I can only use the second IF function, as the value_if_false part of the first IF test.Is that correct about the second IF function?I think I've got that formula to work this time. Thanks for taking the trouble to read this anyway.https://community.betfair.com/general_betting/go/thread/view/94082/23482366/excel-help?post_id=419439414#419439414I think I've got that formula to work this time. Thanks for taking the trouble to read this anyway.Tue, 29 Dec 2009 16:46:10 -0600I'm trying to do the following =if(e2=b1,if(c2 islessthan d2,1,0)) but as I understand it I can only use the second IF function, as the value_if_false part of the first IF test.Is that correct about the second IF function?https://community.betfair.com/general_betting/go/thread/view/94082/23482366/excel-help?post_id=419439410#419439410I'm trying to do the following =if(e2=b1,if(c2 islessthan d2,1,0)) but as I understand it I can only use the second IF function, as the value_if_false part of the first IF test.Is that correct about the second IF function?Tue, 29 Dec 2009 16:43:56 -0600