I pay sales commission that varies based on profit margin
I need a formula based on the margin:
目前分類:title (4957)
- Nov 03 Mon 2008 20:47
Formula for determining sales commission
- Nov 03 Mon 2008 20:47
Open many workbooks in Excel amp; print one page
I have 80 workbooks that I need to open and print the summary tab for each
one and then close. Does anyone know how I could do this all at one time?
- Nov 03 Mon 2008 20:47
Age and Number Years of Service
I am trying to write a formula that is able to return the earliest possible
year of retirement based on years of service and age. The conditions are
- Nov 03 Mon 2008 20:47
how to create a formula to hide specific rows after meeting requi
- Nov 03 Mon 2008 20:47
Control Display of Drop Down List in Validation
- Nov 03 Mon 2008 20:47
Formatting Cells
I have a document with several different worksheets that are linked. I want
to modify one of the sheets, but no matter what I do, there is one column
- Nov 03 Mon 2008 20:47
Coloured Cells
Is it possible to use a formula to return a value of True if a cell you refer
to is coloured or not? What I want to do is: If Sheet1 A1 is shaded red,
- Nov 03 Mon 2008 20:47
VLOOKUP question...it probably can't...
- Nov 03 Mon 2008 20:47
VBA Help
Hi,
I got this formula that gives me the possibility to extract data when i type
- Nov 03 Mon 2008 20:47
???Refer to a specifc cell in a named range
Just wonderif i name a range, is there a formula that I can refer to a
specific cell in that range
- Nov 03 Mon 2008 20:47
Text box in drawing toolbar in Excel
Once I created a text box, I would like to delete the border so it shows only
the text and no border when printing.
- Nov 03 Mon 2008 20:47
Could you recommend an Excel book?
Could somebody recommend me a book with some advanced Excel functions. I
don't need a book for beginners and I don't need a book that repeats simple
- Nov 03 Mon 2008 20:47
About Macros for Excel
It is important to me to get all about macros for Excel. I want to look up
some reliable PDF reference or another type de file or link to learn from
- Nov 03 Mon 2008 20:47
Convert muliple data into columns
What I have is
- Nov 03 Mon 2008 20:47
Lookup Funtion
I have a lengthy spreadsheet (16000 Rows with data spanning columns A-H). I
would like to allow user of the spreadsheet to enter a single value into a
- Nov 03 Mon 2008 20:47
remove read only
I am working with a network server. One person created an excel sheet that
is to be added to by others. She did NOT create it as read only. However,
- Nov 03 Mon 2008 20:47
How to remove duplicate events in column
Hi,
I need to remove duplicate events from say: A1 to A500.
- Nov 03 Mon 2008 20:47
SQL.REQUEST not working in EXCEL 2003
What do I nned to turn on/install/download to get this function to work.
getting #NAME? error.
- Nov 03 Mon 2008 20:47
Problem withe ABS Function
I've got an unusual problem with the ABS (absolute value) function in Excel 2002 SP 3 running on Windows XP Home SP 2.
- Nov 03 Mon 2008 20:47
About lineal graphic
Hello,
I want to create a lineal graphic, but when there are not all the values of