IF Nested Formula depending on a "Data Validation List"

[Ciprian Campeanu]

HI,

I`am trying to use a formula to calculate some data depending on a "Data validation List" .
Briefly I want to calculate the quantity to be sold depending on the contract type.

I have attached the excel.

I appreciate your help and support.
Thank you ,

Ciprian

[bebo021999]

Try:

Please Login or Register  to view this content.

[AliGW]

Four nested IFs:

=IF(A3="Target",(D3/189)+I3,IF(A3="Platinum ",(D3/189)*4.2,IF(A3="Gold ",(D3/189)*4.6,IF(A3="Silver ",(D3/189)*5,0))))

Note that the metals have trailing spaces in the validation list.

[ORoos]

Hi Ciprian Campeanu,

Try in F3: =IF(A3="Target",(D3/189)+I3,IF(A3="Platinum",(D3/189)*4.2,IF(A3="Gold",(D3/189)*4.6,IF(A3="Silver",(D3/189)*5,""))))

[arthurbr]

Another one

Please Login or Register  to view this content.

And be VERY cautious with the IFERROR function....

[Limor_OP]

In the straightline fashion:

=IF(A3=Sheet2!$A$4,(D3/189)+I3,IF(A3=Sheet2!$A$1,(D3/189)*4.2,IF(A3=Sheet2!$A$3,(D3/189)*4.6,IF(A3=Sheet2!$A$2,(D3/189)*5,0))))

[AliGW]

Belinda - this won't work because of the trailing spaces I mentioned.

[Bo_Ry]

Another one at
F3
=D3/189*CHOOSE(MATCH(A3,Sheet2!$A$1:$A$4,),4.2,5,4.6,1)+I3*(A3="Target")

[Limor_OP]

Right Ali,
That's why I made a reference to the values listed in sheet2.

[AliGW]

Doh! Not enough caffeine ...

[Limor_OP]

Haha Good Morning!