This should read
=IF(B21=14,B3/2,IF(B21=15,C3/2,IF(B21=16,D3/2,IF(B21=17,E3/2,IF(B21=18,F3/2,IF(B21=19,G3/2,IF(B21=20,H3/2,0)))))))
Note I have removed all the " ,0 " except the last
This works: it has only 7 nested IFs
Why not do the division only once
=IF(B21=14,B3,IF(B21=15,C3,IF(B21=16,D3,IF(B21=17, E3,IF(B21=18,F3,IF(B21=19,G3,IF(B21=20,H3,0)))))))/2
This is shorted and, unlike the others, can be extended since there is no
nesting
=IF(OR(B21<14,B2120),0,INDIRECT(CHAR(B21+52)&"3")/2)
This does away with IF
=AND(B2113,B21<21)*INDIRECT(CHAR(B21+52)&"3")/2
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"IT1Navy" wrote in message
...
How do I get this type of formula to work without it giving me a "Too many
arguments for this function" error:
=IF(B21=14,B3/2,0,IF(B21=15,C3/2,0,IF(B21=16,D3/2,0,IF(B21=17,E3/2,0,IF(B21=18,F3/2,0,IF(B21=19,G3/2,0,IF(B21=20,H3/2,0)))))))
Is there another Function I can use?
--
IT1 Navy