Thanks Jim:

Yes, I guess I could do it that way, because I only have two cost I am
dealing with 6.17 and 7.10 - I thought it would be more efficient to write a
formula.

Jose'

"Jim Thomlinson" wrote:

I assume that somewhere you have or can create a table of the Plans and their
associated costs. At that point I would be inclined to use a Vlookup or
Index/Match formula.
--
HTH...

Jim Thomlinson


"Jose'" wrote:

I want a function that will put a cost amount in the Cost column based on
Plan type; for example if Plan=C then cost will be 6.17 if Plan=A then cost
will be 7.10.

I am not sure if this should be an IF(OR) statement or some other function
and how to write that function.

example

Item Plan Cost
xxx C 6.17
xxx A
xxx C
xxx A
xxx C

Thanks in advance