Forum Discussion
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
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
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")
Thank you, I tried what you said and STILL got the same error message.
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 ;)
