symbols
=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
|