thank you so much, I am working on this one, and Im sure it will work.
--
halegria


"akphidelt" wrote:

You can but you would have to create some if statements or set up a table
with the values. So your formula would consists of Ifs like

=If(B1="C",A1*100,If(B1="K",A1*1000,A1*C1))

Something like that. This will only multiply if the value C or K is in B. If
nothing is in B it will still multiple A and C.

"hugoalegria" wrote:

is there a way to multyply with symbols?? example: in column A I have a
quantiy, in column C1 I have another quantity that when multiplied by each
other gives the result in D1, my question is, can I use a symbol in B1 such
as C for 100, K for 1000 ect. so when the user puts in that symbol the result
in D1 will be automatically figured by that amount?
--
halegria