I got through the 401K after playing with it awhile. Can someone help me with
my last IF function problem. To calculate health cost for each employee by
testing the name of the employee's plan is equal to the name of the health
plan in cell B4. If it is, then the cost of the health plan is equal to the
value in cell C4, otherwise, the cost is equal to the value of cell C5, help1

Try this

cost = IIF(employee's_plan = B4, C4,C5)

Note:
The syntax for the IIF Function is:

IIf(expr, truepart, falsepart)

The IIf function syntax has the following named arguments:

Part Description
exp ----Required. Expression you want to evaluate.
truepart -----Required. Value or expression returned if expr is
True.
falsepart -----Required. Value or expression returned if expr is
False.

IIf always evaluates both truepart and falsepart, even though it
returns only one of them. Because of this, you should watch for
undesirable side effects. For example, if evaluating falsepart results
in a division by zero error, an error occurs even if expr is True.

Hi potsie

Am unfamiliar with "IIF" function, except in a macro context.

But try arthurjr07's function using "IF" instead. And replace
"employee's_plan" with your cell reference or range name.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531744