Sorry if this is in the wrong place, I have no idea where to put it. Hey, I'm starting a little project that calculates the best possible build for a pc based on a number of things (overclocking, SLI, budget etc...) and I'm running into a problem. I'm using multiple an IF statement with multiple conditionals and Im stumped as to how I will make it display some thing heres an image:
http://i.imgur.com/LfngTiz.png
I want in g5 to display the following: "http://uk.pcpartpicker.com/p/1mrYo" However I cant seem to find out how to get it to show that. Here's the code if you're having trouble reading it:
"=IF(C3=No, IF(c5=yes,IF(c7=No, IF(c9=Yes, IF(c11=Yes, If(c13=No, IF(c15=No, IF(c17=Yes, IF(e5=600)))))))))"
I'm confused as to what your ultimate goal is. Do you want to display that URL only if all of the conditions shown in your IF statement are TRUE?
What do you want to display if any one or more of them aren't TRUE?
Are different URL's supposed to be displayed for different combinations of Yes's and No's?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Yes, and for the last question eventually.
You answered the first and last question but you didn't answer the second. I took a guess at what your answer might be...
=IF(AND(C3="No",C5="Yes",C7="No", C9="Yes", C11="Yes", C13="No", C15="No", C17="Yes", E5=600),"http://uk.pcpartpicker.com/p/1mrYo","All conditions have not been met")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |