kimparker0261
New Member
- Joined
- Jan 8, 2019
- Messages
- 30
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>
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>