Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need help.
I have some criteria which consists of the following:
Name | Sales 2018 | Sales 2019 | Growth |
A | 155,471,000 | 218,313,000 | 62,842,000 |
B | 0 | 160,174,100 | 0 |
C | 201,561,300 | 0 | 0 |
D | 335,127,700 | 246,324,000 | -88,803,700 |
E | 87,421,300 | 0 | 0 |
F | 259,059,400 | 275,161,000 | 16,101,600 |
G | 206,104,300 | 185,311,000 | -20,793,300 |
H | 195,334,400 | 0 | 0 |
I | 203,839,100 | 196,328,000 | -7,511,100 |
J | 0 | 389,833,000 | 0 |
K | 491,257,100 | 603,016,100 | 111,759,000 |
L | 440,301,200 | 0 | 0 |
M | 152,800,200 | 178,219,000 | 25,418,800 |
N | 149,862,500 | 0 | 0 |
the idea is that : =IF(AND(C2>0,B2>0),C2-B2,0)
Any Ideas on how I can tackle this would be highly appreciated.
Thank you in advance for your time.
Fandy
try it like this:
=IF(C2>0 AND B2>0,C2-B2,0)
regards
Try
SUM({<C2={">0"},B2={">0"}> } C2-B2)