Forum Discussion

Theresa Bellflower's avatar
Theresa Bellflower
Copper Contributor
Jun 07, 2018

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's avatar
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's avatar
Theresa Bellflower
Copper Contributor
Jun 08, 2018

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

  • Arul Tresoldi's avatar
    Arul Tresoldi
    Iron Contributor
    Jun 08, 2018

    When I was studying your formula I tried my version and it worked (I mean it wasn't any error but the cell gave me "Select Units minutes"). Mr Baklan attached also a document with that formula working ;)

Resources