Excel 2007 : multiple cell value

[Chaosad33]

Im trying to create a value within a cell based on the collective values of 3 other cells. Excel 2007.

Example: If C3 = 1 and A2 = New and E3 = RCA then F3 would = $37.50

[Cutter]

Welcome to the forum.

Based strictly on what you've given us: =IF(AND(C3=1,A2="New",E3="RCA"),37.5,"") and format as currency

[dilipandey]

HI Chaosad33,

Welcome to the forum.

You can use And function with IF function :-
In cell F3:-
= if (and(c3=1,a2="new",e3="rca"),37.50,"")

Regards,
DILIPandey

<click on below 'star' if this helps>

[Chaosad33]

That works great thank you Cutter.

[Cutter]

You're welcome. Please remember to mark your thread as SOLVED (click Forum Rules @ top of page - see rule #9 for instructions).

[Chaosad33]

ok so there is more......the first formula works good but in addition to it if call E3 = kenwood the F3 is 75.00

[Chaosad33]

ok so there is more......the first formula works good but in addition to it if call E3 = kenwood the F3 is 75.00

[Cutter]

Are you sure there won't be others?

=IF(AND(C3=1,A2="New"),IF(E3="RCA",37.5,IF(E3="Kenwood",75,"")),"")

[Chaosad33]

I figured if i seen the general fomula then I could figure out the rest. But here is a further example.

C1 has 3 possible values (1, 2 & 3) this represents the pay level of the installer
A2 has 3 possible values (New, Used & Service) this represents the job type
E3 has 3 possible values (RCA, Kenwood, Samsung) this is the product

With all these options there is a possible 18 differend outcomes so here is 3.

if C1 is 1 and A2 is New and E3 is RCA then F3 should be 37.50
if C1 is 1 and A2 is used and E3 is RCA then F3 should be 17.50
if C1 is 1 and A2 is Service and E3 is RCA then F3 should be 12.00

How do I write this as one?