[Solved] Use of IF in spreadsheets

[colinopen]

Hi there
What is wrong with IF(B2*H2>0; 0; H2)
trying to get the result of B2 multiplied by H2 and give 0 or the result of H2 which is a cell containing the results of 2 cells multiplied.

[robleyd]

Code: Select all

=IF(B2*H2>0; 0; H2)

Don't forget the = sign

Means if the product of B2 and H2 is greater than zero, show zero; otherwise show the content of H2

Is this what you want?

[colinopen]

Just joined and very rusty on spreadsheets.
Thanks so much for the prompt response.

[robleyd]

You might find [Tutorial] Ten concepts that every Calc user should know a useful reference, along with OpenOffice Spreadsheet Tutorial for Beginners with Examples