Help with excel Nest statement?

Question

Here is my nest statement it comes back False in the column, Any help with why ?

=IF(D1="BUCHANAN",F1="24066",(IF(D1="ROANOKE",F1="24019",(IF(D1="TROUTVILLE",F3="24175",(IF(D1="FINCASTLE",F1="24090",(IF(D1="DALEVILLE",F1="24083",(IF(D1="CLOVERDALE",F1="24066",(IF(D1="BLUE RIDGE",F1="24064")))))))))))))

=IF(D1="BUCHANAN",F1="24066",(IF(D1="ROANOKE",F1="24019",(IF(D1="TROUTVILLE",F3="24175",(IF(D1="FINCASTLE",F1="24090",(IF(D1="DALEVILLE",F1="24083",(IF(D1="CLOVERDALE",F1="24066",(IF(D1="BLUE RIDGE",F1="24064")))))))))))))

Answer 1

The reason it comes back false is because you're formula isn't even close to being correct. An If statement should look like this:

=IF( [condition] , [value if true] , [value if false] )

Your statement evaluates if D1 = "Buchanan". If so, it looks after the comma and sees "F1 = 24066" That is supposed to be the value returned if your condition is true (i.e. if D1 = Buchanan). If F1 is equal to anything other than 24066 then your statement will return FALSE. Here are some examples:

Assume that cell A1 = "ABC"

=IF(A1 = "ABC","Great!","Bad")
will return "Great!"

=IF(A1 <> "ABC", "Good","Bad")
will return "Bad"

=IF(A1 = "ABC", 1=1,"Bad")
will return TRUE

=IF(A1 = "ABC", 1=4,"Bad")
will return FALSE

Here's how to do a 'nested' if statement...

Let cell A1 = 66 and B1 = 44

=IF(A1 = 66, IF(B1 = 33, "66 and 33 are the values", "You have 66 but not 33"), "You missed both numbers")
this statement will return "You have 66 but not 33"

Hope this helps!

Answer 2

=IF($C$23="B", IF($C$21="N",$B$13*$B$17*$B$sixteen*C4, $B$13*$B$17*$B$sixteen*(C4*a million.15)), IF($C$21="N",$B$14*$B$17*$B$sixteen*C5, $B$14*$B$17*$B$sixteen*(C5*a million.05))) placed this in all one non-provide up line. wish this facilitates. John

Answer 3

This doesn't tell what you are trying to accomplish.