200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
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.
