How to use IF to use value from another cell

[parnless]

How can I do the following? If C3 is more than 0, then I need what is in I3 (a value from a formula) to be shown in D3, if not then I need D3 to be left blank. Any help would be greatly appreciated. Thanks...

[robleyd]

G'day, and welcome to the community forum.

The syntax for IF is IF(Test; ThenValue; OtherwiseValue). In the offline help - F1 - search if.

In the cell where you want the result to appear:

Code: Select all

=IF(C3 > 0; I3; "")

[RusselB]

First off, Welcome to the Forums.
Your query is really quite simple.
In D3 enter

Code: Select all

=if(C3>0;I3;"")

Please note that the "" puts a null string into the cell, so it looks blank, but if you were to use the ISBLANK function, it would return False as the cell isn't literally blank.
Currently for OpenOffice this is the closest that you can get to having a formula return a blank entry into a cell.