Each of your IFs has one argument too many.
Try leaving out the ,0

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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