| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 48244 | 2004-08-18 00:24:00 | excel help? | Nigel Thomson (629) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 262692 | 2004-08-18 00:24:00 | 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 (629) | ||
| 262693 | 2004-08-18 00:34:00 | ok don't worry, i think i've got it working, (kept useing "then" and 'else"), doh' |
Nigel Thomson (629) | ||
| 262694 | 2004-08-18 00:55:00 | 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 (629) | ||
| 262695 | 2004-08-18 02:08:00 | 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 |
Nigel Thomson (629) | ||
| 262696 | 2004-08-18 02:35:00 | 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? |
Graham L (2) | ||
| 1 | |||||