We found a problem with this formula. Try clicking insert Function on the Formulas tab to fix it

I am trying to get a calculation formula to work but the error message I get is "We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for mo...

excel

Formulas and Functions

Arul Tresoldi

Iron Contributor

Jun 07, 2018

You have to move a parenthesis:

=CONCATENATE(IF(D46="R/hr";ROUND((VLOOKUP(A50;A69:G74;7)*60/(((H14*I14)+(J14*K14)+(L14*M14))/(I14+K14+M14)));0);IF(D46="mR/hr";ROUND((VLOOKUP(A50;A69:G74;7)*60/(((H14*I13)+(J14*K14)+(L14*M14))/(I14+K14+M14))/2000);0);"Select Units"));" minutes")

Instead of

=CONCATENATE(IF(D46="R/hr",ROUND((VLOOKUP(A50,A69:G74,7)*60/(((H14*I14)+(J14*K14)+(L14*M14))/(I14+K14+M14)),0),IF(D46="mR/hr",ROUND((VLOOKUP(A50,A69:G74,7)*60/(((H14*I13)+(J14*K14)+(L14*M14))/(I14+K14+M14))/2000)),0),"Select Units"))," minutes")

Theresa Bellflower

Copper Contributor

Jun 08, 2018

Thank you, I tried what you said and STILL got the same error message.

Forum Discussion

We found a problem with this formula. Try clicking insert Function on the Formulas tab to fix it