Forum Discussion
Solved
If, Else, But formula?
How do I write a formula that goes like this: If A2 is greater than 10, SUM1, else SUM2, but if A2 is blank, insert "0" This bit works great: =IF(A2>10,SUM(A1,B1),SUM(A1,C1)) I can't figure...
=IF(A2="", 0, IF(A2>10,SUM(A1,B1),SUM(A1,C1)))
or
=IF(A1="", 0, SUM(A1, IF(A2>10, B1, C1)))
=IF(A2="", 0, IF(A2>10,SUM(A1,B1),SUM(A1,C1)))
or
=IF(A1="", 0, SUM(A1, IF(A2>10, B1, C1)))
HansVogelaar These both work beautifully. Thank you!
