Karenc

[Karenc1959]

I am getting an invalid return in the first box of the fx wizard (using the if function). I am trying to say: if Cell A says 401K, return the value of Cell B or 0 if it does not say 401K.

Thank you.

 

[VoG]

Hello and welcome to MrExcel.

Is it?

=IF(A1="401K",B1,0)

 

[Karenc1959]

Yes-that did the trick! It was the parens that were throwing me off. Thanks a million!