Combining if statement and Isblank

[kimparker0261]

I have the formula for this spreadsheet, if cell a2 is greater than 0 then display the information from a new sheet and the cell f9, but I also need to put in the if statement if the cell is blank then dont display any information. Can this formula be done .

this is the first half of the formula to show if the cell is less greater than zero to display the information on the other sheet from cell F9, the help I need is to update the formula to say If A2 is blank then leave the cell blank.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=IF(A2>0,Sheet2!F9,"")
</code>

 

[crazydragon84]

If(A2="","",IF(A2>0,Sheet2!F9,""))

 

[kimparker0261]

Ok maybe I am missing something so can you talk it out to me, because it suppose to read that if A2 is blank then dont input the information from the cell, but if A2 is greater than 0 then enter line information from sheet1 Cell F9

 

[fhqwgads]

"" is basically the same as a blank cell
in If(A2="","",
If(A2="" is checking if the cell is blank and if true puts "" in the cell
if you really wanted to use the IsBlank formula i think it's something like this
=If(IsBlank(A2)=TRUE,"",IF(A2>0,Sheet2!F9,""))

 

[kimparker0261]

I used your formula to update the cell and check this out
this is the updated formula
=IF(ISBLANK(Input!G9)=TRUE,"",IF(Input!G9>0,Input!H9,""))
Input G9 is the cell on the first sheet that if blank then leave line blank, but if the cell is greater than 0 then input the information from the cell.

did I do something because the if greater than part is not working.

 

[Fluff]

How about
=IF(OR(Input!G9="",Input!G9<=0),"",Input!H9)

 

[kimparker0261]

This is cool when i enter 0, but if the fieldis blank it is not working .

 

[Fluff]

In that case I suspect that G9 is not really blank.
In an empty cell on the input sheet put =isblank(G9) what does it return

 

[kimparker0261]

It returns false , even when I put a value it says false

 

[Fluff]

In that case the cell is NOT blank