Cells not multiplying correctly.
Hi,
I have two adjoining cells that are not multiplying correctly.
I have tried =[part qty] * [module type] and the formula returns "10" when it should return "20"
I have tried =[part qty]@row 8 [module type]@row and the formula return "10" when it should return "20"
Any help would be greatly appreciated.
[Module Type} is a Match with Index formula.
Best Answer
-
Try:
=Value([part qty]@row) * value([module type]@row)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Try:
=Value([part qty]@row) * value([module type]@row)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!