Thank you it worked like a charm.
--
halegria


"Gary''s Student" wrote:

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

and if you have lots of symbols, use VLOOKUP() rather than IF().
--
Gary''s Student - gsnu200785


"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