Multi IF function not working
There are two ways to fix your formula (specifically):
=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)
or:
=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)))))))
However, there are other ways of going about it - here's one way with
some error checking:
=IF(OR(B21<14,B2120),"",INDEX(B3:H3,B21-13)/2)
Hope this helps.
Pete
On Feb 2, 6:52*pm, IT1Navy wrote:
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
|