LinkBack URL
About LinkBacks
Please Login or Register to view this content.
Why can't the code get results
Cell A1 Key in OD9.525*0.8mm*850mmL
formula like this ((9.525-0.8)*850*8.96)/1000
Cell B1 Get result is 66.4496
Please Login or Register to view this content.
Why can't the code get results
Cell A1 Key in OD9.525*0.8mm*850mmL
formula like this ((9.525-0.8)*850*8.96)/1000
Cell B1 Get result is 66.4496
Last edited by choletseng; 02-23-2024 at 08:41 AM.
You need to remove "OD" from first dimension and "L" from units of last dimension.
Use REPLACE if these are generic values.
Temporary code:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Try change
toPlease Login or Register to view this content.
With Regular ExpressionPlease Login or Register to view this content.
Please Login or Register to view this content.
Remove "OD" and the letter "L" from cell A1
or insert "L" into your formula for ln.
If you do that you get the correct result
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Wow, you two are so amazing. The problem has finally been successfully solved. Thank you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks