Error on Excel Formula

0

I have created an excel formula that keeps giving me an error in formula message and I don't know what is wrong with the formula. Can anyone have alook and see where I have gone wrong.

This is the formula I am trying to use.

=IFERROR(K8*(IF(L8="N/A",1,(1-0,2*L8/100)))*(IF(M8="N/A",1,(1-0,2*M8/100)))*(IF(N8="N/A",1,(1-0,2*N8/100)))*(IF(O8="N/A",1,(1-0,2*O8/100)))*(IF(P8="N/A",1,(1-0,2*P8/100))),0)

Thanks in advance

Answer
Discuss

Answers

0

This is the error:

(1-0,2*L8/100)

this part doesn't mean anything, but it looks like maybe you inteded for that part to be a function, I'm not sure. You have this section in every IF statement.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login