New
#1
Hide formulas
Hi All,
I am designing a form in Excel to be used in manufacturing.
Since math seems to be a problem in our company I included some formulas to automate the process and cut down on mistakes.
In the screen shot you can see the first 4 columns that have to be entered by the user and then the form will calculate the fields:
Slat width
Rail Height
Housing width
Axle width
If there is nothing entered in the first 4 columns, I would like the fields that do calculations to be blank to make it less confusing. They should only show anything when a value is entered in column 1-4
So the question is how do I do that?
Anyone?
Thanks
Sven