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 more info on common formula problems. The formula I wrote is: =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") I can't find the error on this formula even though all the parenthesis are accountable. Thank you, T

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")

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jun 08, 2018

    Hi Theresa,

     

    I cannot understand the formula, and what you're trying to do, but I've got rid of the error message by fixing it this way:

    =CONCATENATE(IF(D46="R/hr",ROUND((VLOOKUP(A50,A69:G74,7,0)*60/(((H14*I14)+(J14*K14)+(L14*M14))/(I14+K14+M14))),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"))

     

    Regards

Resources