If you can only have A or C in the Plan column, then this would be
simple:

=IF(B2="C",6.17,7.1)

and you could extend this quite easily if you had a few more
acceptable values. If there is some relationship between the Plan
value and the Cost value, then you could calculate it.

However, if you had more variables in the Plan column, then you could
think about building up a 2-column table somewhere that had the Cost
associated with each variable, and then you could use VLOOKUP.

Hope this helps.

Pete

On Sep 23, 4:24*pm, 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