I am writing a very important program and have been stuck on this for a few days now,,, please help.
this is for a program called drive works; if I know the Height and Width I need to suppress a certain part from my assembly.
Height>=30
30<= Width <36
46<= Width <60
If Height<30 right off the bat the equation in false if its true and my width falls inbetween either of the bottom two equation my formula is true.
if True= "Unsuppress"
if false= "Suppress"
Last edited by lhernandez900; 04-19-2013 at 01:59 AM. Reason: TITLE CHANGE
please read http://www.excelforum.com/forum-rule...rum-rules.html next time before posting
Sounds like you just need a nested IF statement
Little confused about the height and width bit
if height >30 and
width is below 30 and 36?
width is below 46 and 60?
please clarify
try this:
Formula:
Please Login or Register to view this content.
the bold italic height and width are the values or ranges you are getting the data from, change accordingly
Hope this helps
EDIT-
ADDED Underlines, as it was hard for me to see the Bold Italic script in lower-case
Last edited by dredwolf; 04-19-2013 at 01:58 AM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi and welcome to the forum
We would love to help you with your question, but 1st, in accordance with forum rules, please rename your thread to something more meaningful, that actually describes your problem.
Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.
Many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertise, they might only open those threads.
Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title
Also please note...do not post duplicate threads. I have closed your other thread, you can continue on this 1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
How can one delete a reply?
Moderator's can only delete posts from the forum.
Last edited by ExcelHelper2; 04-19-2013 at 02:02 AM. Reason: The question was already answered
Sorry FDibbins, I always seem to be replying when you give this message
did not work!!
well, what DID happen? and I stiill think FDibbins ban is in place...so, Change title to something that can be google searched, AND post a workbook that we can work on....
@ Dred, not a problem, just a timing thing
@ ExcelHelper2, no need to delete the post, just the fact that you said "post deleted" is fine, thanks
I imputed H=60 and W=51 and the answer was "suppress"
PLEASE, re-read post #8, (INCLUDING the signature(Bottom part of post)) and upload a sample, I can not tell you what is going wrong when I can not see what is going wrong....
please confirm your expected results
Height < 30 = Suppress
Height > 30 and width between 30 and 36 = Suppress
Height > 30 and width between 46 and 60 = unsuppress
??
Hello,
Is this what you are looking for?
Supress or Unsupress.xlsx
Assuming you have Height on Cell A2, and Width on Cell B2, copy paste this formula in Cell C2
Please Login or Register to view this content.
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
That looks uunsurpisingly familiar
*gasp* I'm sorry dredwolf, it IS familiar ... I just did whatever you posted without knowing it
LOL, no problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks