New Posts For Thread: Excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/23468750/excel-helpI got a problem putting a formula in a cell. What I want is a cell value minus another cell value only if the the first cell has a number larger than 100. So for example I want =C1-A1 If C1100 in a new cell. When I put that =C1.... in, it says it is=IF(C1 gt 100, C1-A1, "")Replace gt with the greater than symbol which doesn't display properly on this forum.https://community.betfair.com/general_betting/go/thread/view/94082/23468750/excel-help?post_id=419142238#419142238=IF(C1 gt 100, C1-A1, "")Replace gt with the greater than symbol which doesn't display properly on this forum.Sat, 14 Nov 2009 08:26:08 -0600I got a problem putting a formula in a cell. What I want is a cell value minus another cell value only if the the first cell has a number larger than 100. So for example I want =C1-A1 If C1100 in a new cell. When I put that =C1.... in, it says it ishttps://community.betfair.com/general_betting/go/thread/view/94082/23468750/excel-help?post_id=419142234#419142234I got a problem putting a formula in a cell. What I want is a cell value minus another cell value only if the the first cell has a number larger than 100. So for example I want =C1-A1 If C1100 in a new cell. When I put that =C1.... in, it says it isSat, 14 Nov 2009 08:22:21 -0600