=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

If has three arguments... you have four
1. C2="H"
2. B2
3. 0
4. If(d2="H",b2,0)

I think what you want is this
C2="H",B2,If(d2="H",b2,0))
"phowe43" wrote:

=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

=IF(C2="H",B2,0,If(d2="H",b2,0))

After the first 0 Excel is expecting a closing ")". That's why you get the
error message.

Try one of these:

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

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



--
Biff
Microsoft Excel MVP


"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

Question 1. How many arguments does the IF function want? [See Excel help
if you don't know.]

Question 2. How many arguments does your outer IF function have?
--
David Biddulph

phowe43 wrote:
=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

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

T.Valko - your second option worked like a champ.

Thanks everyone for your input.

"phowe43" wrote:

=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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"phowe43" wrote in message
...
T.Valko - your second option worked like a champ.

Thanks everyone for your input.

"phowe43" wrote:

=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