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 mo...
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
