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>

 

[kimparker0261]

Good morning,
I am entering the formula like this
={IFERROR(INDEX(Input!C$4:C$9,SMALL(IF((Input!$C$4:$C$9<>"")*(Input!$C$4:$C$9>0),ROW(Input!$C$4:$C$9)-ROW(Input!$C$4)+1),ROWS($1:1))),"")} then I hit Ctrl+Shift+Enter and I am getting an error

 

[Fluff]

Do not include the braces {} when you enter the formula.
They will be added automatically when you hit Ctrl Shift Enter

 

[kimparker0261]

Ok I got it thanks, however can you talk out the formula for me today i am lost

 

[Fluff]

If you mean how does it work, have a look here https://exceljet.net/formula/get-nth-match-with-index-match

 

[kimparker0261]

can you update the linkl for the spreadsheet and send me the link back

 

[kimparker0261]

OR can you do the formula to excuse the zeros and blanks from this formula
=IF(OR(G10="",Input!G10<=0),"",Input!F10)

 

[Fluff]

There is nothing in G10, so I don't understand what you're saying.

 

[kimparker0261]

Good Morning,
I am trying to work with the formula
=IFERROR(INDEX(Input!C$4:C$9,SMALL(IF((Input!$C$4:$C$9<>"")*(Input!$C$4:$C$9>0),ROW(Input!$C$4:$C$9)-ROW(Input!$C$4)+1),ROWS($1:1))),"")

to remove the blank rows and zeros , for the form I am attaching the sheet can you please help and update if column C5 equal a zero or a blank row remove the row from the spread sheet.

This is the spreadsheet link

https://1drv.ms/x/s!AoRYGdvX8gxwgVcK1aoWsJmw6Gtq

 

[Fluff]

In what way doesn't that formula work? (other than you aren't using it)

 

[kimparker0261]

What column can I post the formula in