Calc >or <

[sprit36]

Good morning, I am trying to solve a doubt that I have in a formula. In cell A if the value is equal to or less than 0 calculate cell A with B, but if it is greater than zero it should not add to cell B. Thanks.

[6StringJazzer]

This is a rather compact way to do it.

Please Login or Register  to view this content.

[AliGW]

In C2 copied down:

=IF(A1<=0,SUM(A1:B1),B1)

[sprit36]

Thanks for the answers, the formula: error appears when I paste it in Excel, I have not been able to test it. The first one I think works, I'll try the file I need to see if it works. When you try it, notice if it works.

[AliGW]

Which of us are you addressing? If my solutions are untested, I say so. Here they have been tested. See below:

Excel 2016 (Windows) 32 bit

	A	B	C
1	2170	2106.82	63.18

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	A	B	C
1	2170	=A1-(A1*0.029)-0.25	=A1-(A1-(A1*0.029)-0.25)

Sheet: Sheet1

[6StringJazzer]

In C2 copied down:

=IF(A1<=0,SUM(A2:B2),B2)

This formula doesn't work because A1 should be A2.

I have attached the original file with my formula, and a corrected version of Ali's formula. Both match your desired results.

[AliGW]

Well spotted! Doh!!! I'll amend my original post.

[sprit36]

Thanks, it works perfectly. Thank you very much for your help.