Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Hide formulas

23 May 2014   #21
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Sooooooo close - I could say that I left it as an exercise for the student, but that would be lying

Thanks again Tanya. It's nice that someone who has current working knowledge with Excel is here on the thread. Sven would still be trying to figure out what I was trying to convey if you weren't

Bill
.


My System SpecsSystem Spec
.
23 May 2014   #22
Sven1458

windows 7 ultimate x64
 
 

Tanya,
you are amazing, when I started this, I hade no clue where to go. The only thing I could do was write simple formulas.
this in a lot higher on the ladder of Excel, and I am excited to learn more.
I will spend the weekend trying t make this work.
thanks gain for your help

Sven
My System SpecsSystem Spec
23 May 2014   #23
Sven1458

windows 7 ultimate x64
 
 

Hi Tanya
I put those formulas in and it worked like a charm.
I had to change the column / cell numbers, but got it done.
Now I was wondering if you could give me the formula for the following problem:
The side plate size (J) depends on the total height (D).
Total height up to 170 will need a side plate of 15
Total height up to 240 will need a side plate of 18
Total height up to 350 will need a side plate of 20.5
Can you come up with a formula that will display the correct Side plate size when I type the height?
Thanks for your help,

Sven


Attached Thumbnails
Hide formulas-capture.jpg  
My System SpecsSystem Spec
.

24 May 2014   #24
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

When you say "up to" are you saying that lower values would also get the various side plate size, or are there only 3 allowable total height values.

For example, could I have total height values of 145, 219, 299, 308 and 349 which would give results of 15, 15, 18, 20.5 and 20.5?

What do you want if the total height is greater than 350?

If it's just the three values, the formula is just another nested IF statement.

Eg. If($C5="","",if($D5=170,15,if($D5=240,18,if($D5=350,20.5,"ERR"))))

Thanks
Tanya
My System SpecsSystem Spec
24 May 2014   #25
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

I'll sit back and keep an eye on the thread, for now Tanya has the lead and is in a better position, having Excel, to help you Sven.

@Tanya: you should get a consulting fee from Sven's company... or at least a Tshirt

Good luck and have fun,

Bill
.
My System SpecsSystem Spec
24 May 2014   #26
Sven1458

windows 7 ultimate x64
 
 

Hi Tanya,
thanks for sticking with me.
to clarify:
any height between 0 and 170 requires a side plate of 15
at 171 up to 240 requires a side plate of 18 and anything beyond that requires a side plate of 20.5. the height limit is 350 and will fit into a 20.5 plate. nothing bigger is manufactured by us. lets say the height is 144, the plate would be 15 if the height is 222, it would be 18, if 308 it would be 20.5
hope this clarifies it.
again thanks for your help

Sven
My System SpecsSystem Spec
25 May 2014   #27
Sven1458

windows 7 ultimate x64
 
 

Hi Tanya,
I modified your formal: If($C5="","",if($D5=170,15,if($D5=240,18,if($D5=350,20.5,"ERR"))))
to: If($d13="","",if($D13<=170,15,if($D13<=240,18,if($D13<=350,20.5,"ERR"))))

now it does what I want it to do.

Thanks for all your help.
Sorry, we don't have T-shirts and I don't get paid for this either. Just dedication to the company.

Thanks Again.


Sven
My System SpecsSystem Spec
25 May 2014   #28
Sven1458

windows 7 ultimate x64
 
 

I have another Question:
is it possible that after data input in the first 4 columns, the form must be printed and can not be saved with the data in it? Tis way the form is always empty when you open it.

Thanks
Sven
My System SpecsSystem Spec
25 May 2014   #29
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Quote   Quote: Originally Posted by Sven1458 View Post
Hi Tanya,
I modified your formal: If($C5="","",if($D5=170,15,if($D5=240,18,if($D5=350,20.5,"ERR"))))
to: If($d13="","",if($D13<=170,15,if($D13<=240,18,if($D13<=350,20.5,"ERR"))))
Sven
Well done! Looks like you've got the hang of this stuff.

Tanya
My System SpecsSystem Spec
25 May 2014   #30
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Quote   Quote: Originally Posted by Sven1458 View Post
I have another Question:
is it possible that after data input in the first 4 columns, the form must be printed and can not be saved with the data in it? Tis way the form is always empty when you open it.

Thanks
Sven
Not that I can think of using native excel functions. It is possible with some vba code, but that is probably overkill.

However, you could make the excel file read only, so it couldn't be saved.
My System SpecsSystem Spec
Reply

 Hide formulas




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
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 (Auto-Hide) 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 auto-hide. So is this possible? Note: You have to look really close to see it.
Themes and Styles
Auto-hide Taskbar Fails to Auto-hide
I set the Taskbar tab (in Taskbar & Start menu Properties) to Auto-hide the Taskbar. When I select Apply, the taskbar dips and disappears for a second and then comes right back and stays there. Is there a way to make the auto-hide work? W7 Home 6.1 / 7600 Thank you
General Discussion
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
how do you hide ur ip ??
i was barred / band from a site :) nothing serious had a dissagreement , anyway they new my ip so i gather this is how i was banned . as when i go to enter i cant. so i downloaded hide my ip full version , got back on the site using a fake ip address in england . anyway used that same ip...
General Discussion
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 20:45.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App