PDA

View Full Version : excel help?

Nigel Thomson
18-08-2004, 12:24 PM
greetings all

I have a price list, for a variety of products (4500ish) and I need to do the markups, and need a bit of help working out the formulae (I haven't really used Excel at all) ,

for example

if the price in col 2 is <= \$0.49 then the mark up is a factor of 2,
if the price in col 2 is <= \$0.99 and >=\$0.50 then the mark up is a factor of 1.5,
if the price in col 2 is <= \$1.49 and >=\$1.00 then the mark up is a factor of 1

I hope that explains what I am trying to do,

Thanks Nigel

(those aren't the real markup figures of course)

Nigel Thomson
18-08-2004, 12:34 PM
ok don't worry, i think i've got it working,

(kept useing "then" and 'else"), doh'

Nigel Thomson
18-08-2004, 12:55 PM
ok i'm back,

i have 21 different mark-up levels depending on the price

excel only allows 7 levels of nesting

is there a way around this?

Nigel Thomson
18-08-2004, 02:08 PM
my part numbers are being displayed like this
1.12122E+11

but in the formulae bar they appear like this
112121700001 --which is how I want them to appear,
the field/column is set to text, I can set it to number which soves the problem

but is there a way to prevent excel, displaying them in that format 1.12122E+11 as when I save to .csv it saves them in that format, (unless the field has been changed to number), I would rather keep the parts list as a text column as some part numbers are alphanumeric

thanks

Nigel

Graham L
18-08-2004, 02:35 PM
Excel takes a text field and converts it to scientific notation? Weird.?:| And destructive if it knocks off a few digits of precision. :O

Could it be that the text field isn't wide enough to display all the characters?