# IF Nested Formula depending on a "Data Validation List"

1. ## IF Nested Formula depending on a "Data Validation List"

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  Register To Reply

2. ## Re: IF Nested Formula depending on a "Data Validation List"

Try: ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: IF Nested Formula depending on a "Data Validation List"

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.  Register To Reply

4. ## Re: IF Nested Formula depending on a "Data Validation List"

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,""))))  Register To Reply

5. ## Re: IF Nested Formula depending on a "Data Validation List"

Another one
Formula:  `Please Login or Register  to view this content.`

And be VERY cautious with the IFERROR function....  Register To Reply

6. ## Re: IF Nested Formula depending on a "Data Validation List"

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))))  Register To Reply

7. ## Re: IF Nested Formula depending on a "Data Validation List"

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

8. ## Re: IF Nested Formula depending on a "Data Validation List"

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

9. ## Re: IF Nested Formula depending on a "Data Validation List"

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

10. ## Re: IF Nested Formula depending on a "Data Validation List"

Doh! Not enough caffeine ...   Register To Reply

11. ## Re: IF Nested Formula depending on a "Data Validation List"

Haha Good Morning!  Register To Reply