I use this formula in my pricing sheets I have 1 column where e c or m is
entered and prices are calculated with the following if statement

=C13*(IF(D13="e",B13,(IF(D13="c",B13/100,IF(D13="m",B13/1000,IF(D13=0,0,"err"))))))



Duane Reynolds

"Judy" wrote in message
...
I have a worksheet that needs to do the following:
qty x price (divided) by (c=100 or m=1000 or each=1, etc.)
The cell will have the letter in it to represent the number.
Any help would be appreciated.