Excel

[whitefish2]

I created an excel workbook that has several sheets. I have one worksheet that is INPUT and another sheet that is OUTPUT. The INPUT sheet is for data entry only, with the OUTPUT sheet being the invoice generated from the data entered in the INPUT sheet. What I can't figure out is how to have the cells on the OUTPUT sheet come back empty if they are not utilized on the INPUT sheet. Any suggestions are appreciated.

 

[Dreamboat]

Let's suppose Input sheet has cell A2 empty, but you refer to it in Output sheet.

On Output sheet, put this formula, or incorporate this formula into your existing formula:

=if(isblank(Input!a2),"",MyFormula)

or

=if(Input!a2="","",MyFormula)
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[whitefish2]

Thanks, Dreamboat!