Click here for important information about Computing.net.

Solved How do I get this IF statement to work?

Tags:
Microsoft Excel 2010 - complete product...
excel formula
July 30, 2013 at 17:54:03
Specs: OS, AMD 8350 5ghz / 16 gigs
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)))))))))"


See More: How do I get this IF statement to work?

Report •

#1
July 30, 2013 at 18:02:48
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.


Report •

#2
July 30, 2013 at 18:06:56
Yes, and for the last question eventually.

Report •

#3
July 30, 2013 at 19:46:23
✔ Best Answer
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.


Report •
Start a discussion
Related Solutions
See More ↓


Ask Question