=IF(B3=1,"12", (IF(B3=2,"8", (IF(B3=3,"5", (IF(B3=4,"3", (IF(B3=5,"2", (IF(B3=6,"1", (IF(B3=7,"0", (IF(B3=8,"0", (IF(B3=9,"0", (IF(B3=10,"0", )))))))))))))))))))
2007-12-21 02:19:41 · 4 answers · asked by chicagobrokerguru 2 in Computers & Internet ➔ Software
this should work ,
please put the formula back together again
=IF(B3=1,"12", (IF(B3=2,"8", (IF(B3=3,"5",
(IF(B3=4,"3",(IF(B3=5,"2",
(IF(B3=6,"1","")))))))))))
2007-12-24 00:24:49 · answer #1 · answered by David M 6 · 0⤊ 0⤋
As said above too many nested if statements. An easy way to handle the nested if statements issue is to load the values you want looked up in another area of your spreadsheet and use the vlookup function. You use this to lookup one value and return a corresponding value.
2007-12-21 03:23:05 · answer #2 · answered by Chad H 3 · 0⤊ 0⤋
Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests
2007-12-21 02:40:16 · answer #3 · answered by Thegodwings 3 · 1⤊ 0⤋
Too many nested if statements. In this specific example you can re-write to:
=IF(B3=1,"12",IF(B3=2,"8",IF(B3=3,"5",
IF(B3=4,"3",IF(B3=5,"2",
IF(B3=6,"1","0"))))))
(Yahoo Answers will not display this formula if I write it on one line)
2007-12-21 02:42:37 · answer #4 · answered by HazMat 4 · 0⤊ 0⤋