How to multiply positive or negative values only

[combos]

Help me in this plese:

how to make formula to multiply one value with the second one
only if the second one is positive (or negative).
Thank you!

[Tony Valko]

What result would you expect if the number is NOT positive (or negative)?

[reagan.kha]

Assuming column A is the first number and column B is the second. Also if the second number is negative, it will return a blank.

Please Login or Register  to view this content.

[combos]

Assuming column A is the first number and column B is the second. Also if the second number is negative, it will return a blank.

Please Login or Register  to view this content.

=IF(B1>0;A1*B1;"") and will wor fine. Thank you!