Excel IF Statement

[Elizsk]

I want to use an IF statement in excel that will do the same calculation over and over again for the column and once it hits a negative value it will calculate the one negative value and then the rest afterwards will be zero (because the following will still be negatives). The IF statement I tried to use was =IF(Q22>=0,R21+Q22,0), however when Q = '-' then it doesn't calculate R it will just insert 0.

 

[alansidman]

Please use XL2BB to upload a sample data that we can manipulate. We cannot manipulate the data in a picture.

 

[mart37]

IF(Q22>=0,R21+Q22,IF(Q21<0,0,R21))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(OR(Q21>=0,Q22>=0),R21+Q22,0)