ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Equation Blank cells until input is added (https://www.excelbanter.com/excel-discussion-misc-queries/245882-excel-equation-blank-cells-until-input-added.html)

Ross @ Unirope

Excel Equation Blank cells until input is added
 
I am creating a calculator of sorts. I have a row of 5 cells that are
involved. The first 2 cells are have my data, the next two cells are results
& the last cell is my input. I want the "result" cells to look blank until I
add data into the "input" cell. Can this be done?

Luke M

Excel Equation Blank cells until input is added
 
follow this structu

=IF(ISBLANK(InputCell),"",YourFormula)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ross @ Unirope" wrote:

I am creating a calculator of sorts. I have a row of 5 cells that are
involved. The first 2 cells are have my data, the next two cells are results
& the last cell is my input. I want the "result" cells to look blank until I
add data into the "input" cell. Can this be done?



All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com