CODEWITHSUNDEEP
google-sheetsspreadsheetnegative-number
Andrzej Martens
Andrzej Martens

Reputation: 31

Google spreadsheets - negative number to zero

I am using following formula in Google spreadsheets =K69*0,09 I need to show a result only as a positive number. I need to set negative numbers to zero. Max function does not work. How else can I do that ?

Upvotes: 0

Views: 1292

Answers (3)

Andrey Press
Andrey Press

Reputation: 11

Excellent method, if query too big:

ARRAYFORMULA( IF(A:A="some value"; ARRAYFORMULA( LAMBDA( array; if(array<0; 0; array)) (any result from B:B if A:A="some value") ); C) )

Upvotes: 0

player0
player0

Reputation: 1

use this:

=IF(K69*0,09<0; 0; K69*0,09)

Upvotes: 1

mansuetus
mansuetus

Reputation: 822

=max(0;C4*0,09) works fine here. But when you cannot use MAX, use :

=if(C4<0;0;C4*0,09)

Upvotes: 3

Related Questions