jeudi 7 avril 2016

Excel if A1=in between 17 to 20.4 and B1=in between

thanks for reviewing my request, most likely it is simple formula but I'm stuck in research and trying all different formulas so I really need your help. Any help will be appreciated.

If A1=in between 17-20.4 and B1=in between 10.5-13.4, so C1=7
If A1=in between 20.5-22.7 and B1=in between 14.5-16.2, so C1=8
If A1=in between 20.5-24.5 and B1=in between 12-15.5, so C1=9
If A1=in between 23.5-28 and B1=in between 14-18.5, so C1=10

Both A1 and B1 must match to get value C1, if not 0 or any (error, etc.) All this must be combined formula with for C1 with all values above.

Thank you for all your help. Have a good day! :)

Aucun commentaire:

Enregistrer un commentaire