Forum Discussion
Solved
Help with Excel - Calculating 2 cells based on the text within another
Hello ! I hope someone can help me 🙂 My issue is, I need to calculate the multiplication of 2 cells, when a completely different cell returns a specific text. Eg: Cell A = 10 Cell B = 5 ...
Apologies to be incredibly annoying but I have an extension to that issue.. are you able to assist?
Your formula works great but now i have a simple sum in the next field which is now returning a #value error..
- Cancel that - I've worked it out.
Great to know. If you share result that will be useful for other people in the community.
- Thank you Sergei - This also works perfectly.. very much appreciated.
