## 1 reply

Paste this formula in B1 cell.

=IF(F2=0,6, IF(E2=0,5, IF(D2=0,4, IF(C2=0,3, 999))) ) * A1

Read BELOW FIRST

999 is the value that would be default value in case f2, e2,d2, and c2 are not zero. If that situation occur then what would be your factor of multiplication, I am just giving in this example that in that case it would be 999. You can change it to what should be the right value.

Also note that as soon as condition is met, it will not check so if F2 is 0, it does not care what is e2 d2 c2. In case you care about it, then it needs to be modified

A1 is the value that would be in cell A1 which in your question was 30.