
18 May 2014  #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 14 So the question is how do I do that? Anyone? Thanks Sven 
My System Specs 
. 

18 May 2014  #2 

There's a setting in Excel Options/advanced that has a checkbox for "show a zero in cells that have a zero value".
The default is to have it checked, which will show 0. Try unchecking it. 
My System Specs 
18 May 2014  #3 

Thanks for that tip, it works on the field that has a "0" in it, but not on the other fields because they show a "6.5"
or "0.8". Is there a way to make those disappear? Sven 
My System Specs 
. 

18 May 2014  #4 
x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem

make your formula conditional in each cell you want supressed
If (A1 != ""; calculate value; "") If cell A1 is NOT null calculate the number else write null could be blank or null string. It's been a long time since I wrote Excel formula's  sorry it isn't exact Hopefully you can hit the formula help and work out the exact syntax Bill . 
My System Specs 
18 May 2014  #5 

Thanks Slartybart,
I will try to figure it out. I never wrote anything like that before, just regular formulas. Thanks again Sven 
My System Specs 
19 May 2014  #6 

Slartybart,
I tried to get this going, but can not make it work. can you give me the exact formula, looking at line 1 in my screen shot? total width = 100 should go to 93.5 in slat width and have nothing show when there is on entry in total width. thanks for your help Sven 
My System Specs 
20 May 2014  #7 

In the each of the cells that performs a calculation you would test the value of the dependent cell first, as Bill has shown. So, If we call the first column A, then the formula in EACH of the calculated cells is.. Using positive logic: IF($A1="","",do calculations) or Using Negative Logic: IF($A1<>"",do calculations,"") The operators for "Not equal" are <>, not != I was always taught to use positive logic. But either will work. Now, as regards the Dollar sign; This allows you to copy the formula across other columns and it will always check column A's value for NULL. By not using a $ before the 1, when we copy down we will get the correct row reference. Tanya 
My System Specs 
20 May 2014  #8 
x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem

this should help.... it's in OpenOffice Calc, but spreadsheet formulas are somewhat similar if not the same
=IF(B2;93.5;"") edit: Ignore my typo in the image  B2 is correct if I understand what you want  B3 would test the height not the width.... sorry 'bout that. basically says if there's a value, any value in column 2, set the current cell to 93.5, otherwise make it blank Try that simple formula first, then add your own calculation where I put a static 93.5 
My System Specs 
21 May 2014  #9 

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. ....... They should only show anything when a value is entered in column 14 So the question is how do I do that? I will take the approach of not showing the formula result until multiple cells contain the source values entered by the user. If you need to have all 4 entries before doing the calculation then this could work =IF(COUNT(A2:2)=4,SUM(A2:2),"") which says to count the cells containing a number in the range a2d2 and if that equals 4 then do the calculation sum of the range a2d2 . In my version of Excel the Count function only counts a cell if the value is a number. If you want to be able to count a cell that contains either letters or numbers then use =IF(COUNTA(A2:2)=4,SUM(A2:2),"") but be aware that this will count a cell that contains a space character (looks empty but it is not). Rick 
My System Specs 
21 May 2014  #10 

Thanks to all who responded.
I think I am misunderstanding what you are telling me. The formulas are in the sheet, where do I put: If (A1 != ""; calculate value; "") I am ruing office 2013. I tried to put this with the formula, but that must be wrong. Thanks 
My System Specs 
Thread Tools  
Similar help and support threads  
Thread  Forum  
Excel 2016: Displaying formulas in the formula bar I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64bit. Intel Core i74770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the... 
Microsoft Office  
Hide program hide popup. I have windows media recorder set to record local talk radio for most of the day I have it set to record by the hour, it pops up to alert you its recording....every hour on the hour...and it pops up above EVERYTHING its driving me crazy, anyone know of a hide program program that can hide new... 
Software  
Taskbar (AutoHide) doesn't hide all the way? My friend was wandering how you could get rid of that barely top part of the task bar when it is in autohide. So is this possible? Note: You have to look really close to see it. 
Themes and Styles  
A Program For Mathematical Drawings and Formulas Hi, Does anybody know a program, using which I will be able to make mathematical drawings and write formulas at the same time? Any help will be greatly appreciated! 
Software  
Make explorer hide folders or hide files? In Win 7 64 bit explorer, can I make it show me only folders or only files? Another way of saying this: can I make it hide folders, or hide files? 
General Discussion 
Our Sites 
Site Links 
About Us 
Find Us 
Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd All times are GMT 5. The time now is 14:28. 
