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

[GUS]

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

 

[Qroozn]

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

 

[GUS]

<<why is it in this format
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

 

[Qroozn]

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

 

[GUS]

Yes that's correct..

 

[Qroozn]

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

 

[Yogi Anand]

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

 

[Aladin Akyurek]

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

 

[Qroozn]

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

 

[GUS]

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