![]() |
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? |
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