I am getting a lot of numbers by coworkers in the following format that I have to multiply one by one and add the totals. But must be an easy way.
Does anyone know how to multiply and get a total.
16 @ 1.55 & 25 @ 8 = 224.8
6 @ 3.5 & 4 @ .25 = 22
Thank you for your help.
Numbers and the "@" and the "&" are in cell A1 total in cell A2
Does anyone know how to multiply and get a total.
16 @ 1.55 & 25 @ 8 = 224.8
6 @ 3.5 & 4 @ .25 = 22
Thank you for your help.
Numbers and the "@" and the "&" are in cell A1 total in cell A2