Thanks:  0
Likes:  0

# Thread: How can I multiply 94125 @ 3 & 25 @ 8 and totalize it.

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

2. why is it in this format
try putting = at the front, replacing @ with *, and replacing & with +

[ This Message was edited by: Qroozn on 2002-04-30 21:57 ]

3. < try putting = at the front, replacing @ with *, and replacing & with +>>

That's how they sent to me, I wish they can sent it the way you said.. =), Or better that's how the Boss whan't it to see it in A1 with the totals in A2.. hope make sense for you.

What i was trying to do is in A2 use a formula like.. =LEFT(\$A\$1,FIND(" ",\$A\$1,1))* etc.
or something like that. I been searching the forum, and can't find anything..

[ This Message was edited by: GUS on 2002-04-30 22:06 ]

4. so all you will get currently sent is
16 @ 1.55 & 25 @ 8
is this correct?

5. Yes that's correct..

6. i am trying to work on a substitute formula. but excel wont recognise the "&"..
any ideas anyone else?

7. On 2002-04-30 22:10, Qroozn wrote:
i am trying to work on a substitute formula. but excel wont recognise the "&"..
any ideas anyone else?
Hi Qroozn and Gus:

Try the following formula if A6 house 16@1.55&25@8

=SUBSTITUTE(SUBSTITUTE(A6,"@","*"),"&","+")

Hope This Helps!

_________________
Yogi Anand

Edit: Deleted inactive website from hardcoded signature

[ This Message was edited by: Yogi Anand on 2003-01-19 13:28 ]

8. In A2 enter:

=EVAL(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"@","*"),"&","+")," ",""))

EVAL is a user-defined function, which is part of Longre's Morefunc add-in, downloadable at:

http://perso.wanadoo.fr/longre/excel/downloads/

Aladin

9. try this
a1=16 @ 1.55 & 25 @ 8
a2=SUBSTITUTE(SUBSTITUTE(B21,"@","*"),"&","+")
a3=a2

now a2 converts replaces the symbols, and a3 converts it to a formual

10. Thank you very much..

Qroozn,
Yogi Anand
and Aladin Akyurek

Maybe I miss something I got
16 * 1.55 + 25 * 8

But using the add-in function solved my nightmare.

You guys are the best, thaks again for your time your help and your understanding to a newbee like me.

Best regards
GUS

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•