Maybe put this formula in B9:ok, sorry because i have no experiance in excell. and my english is not good as well so , i have an excell that calculate some values in simple, in B8 there is a value that must be multiplyied with the value on B7 wihch the value ( B7) changes from 1to3 , if is 1 means 10% , 2 means 20% 3 means 30%. , the results goes to cell B9. I hope to be understanding my text. Regards michell
=IF(B1=1,B8*.1,IF(B1=2,B8*.2,IF(B1=3,B8*.3,"ERROR, B1 isn't 1, 2, or 3.")))