Hi,

IF allows only 3 arguments =IF(Test,True,False), you have 4.

It is not clear what you want your formula to do?

But if you are trying to show B2 if C2 or D2 = "H" and 0 otherwise then

=IF(OR(C2:D2="H"),B2,0) (array entered - press Shift+Ctrl+Enter to enter
it)

or without array entry

=IF(C2="H",B2,IF(D2="H",B2,0))
or
=IF(OR(C2="H",D2="H"),B2,0)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"phowe43" wrote in message
...
=IF(C2="H",B2,0,If(d2="H",b2,0))

Any thoughts on why I get a message of...

"You've entered too many arguments for this function"


Thanks so much