Description:
Microsoft Office Excel newsgroup.
|
|
|
Bulk Discount Formula
|
| |
I am looking for a business formula: Basically, I am trying to figure out the best bulk discount per unit as possible to maximize profit. For example: 10 units would sell for $10 dollars each. 100 units would sell for $5 dollars each. If I left a cell blank for units and put it 59 I want excel to calculate... more »
|
|
|
cross hair
|
| |
i am a teacher and use excell for grades . Names on top assignments on the right side. i am trying to make cross hairs what ever cell i click into i will see a color line vertical and horsonal to help me make sure the right grades are entered. i have office 2007 pro.
|
|
|
Vlookup Help
|
| |
Hello, I have a data sheet with information in rows and I use vlookup to match the date/operation/crew and return a value in one of the columns. Now, I have multiple entries where the same date/operation/crew could occur in the same day. Ideally, I want to combine math data in the other cells and have one... more »
|
|
|
SOS! how do I do multiple-value lookup in Excel 2007?
|
| |
I have two regions in exact same places of sheet 1 and sheet 2, I want to find all cells in the region in sheet 1, such that the cell content equal to 0, and then add the numbers at the corresponding locations in the region in sheet 2 up. For example, let's say in the region in sheet 1, there are multiple locations where the cell content = 0:... more »
|
|
|
Trends
|
| |
Having had not much to do - actually nothing with showing a trend on a chart I would like some help. Have setup a chart that shows Name Annual leave Owing Long Service Leave Owing Totals Weeks Leave owing Total days in future of booked leave. How do I show a trend showing leave totals either decreasing or increasing?... more »
|
|
|
Replace entire cell content
|
| |
I have a bunch of names on a spreadsheet and i'm looking for an easy way to replace the names in each cell with a single character, 1, x, etc.
|
|
|
How can I use wildcards in IF statements and Macros
|
| |
I want to include in a Macro, something to take a particular action if the active cell contains text beginning with X. I thought something based on an IF statement, that included a wildcard, might work, e.g. IF(A1="X*,1,0). This does not work though.
|
|
|
How do I count the number of time 2 columns meet my criteria
|
| |
Can anyone tell me what is wrong with this formula? I am trying to say if the text in column B = this, and the text from column C = this, and then count the returned values: =IF(b4:b118,"Consistent Support Staff",IF(C4:C118,"Positive"), "1","0"))
|
|
|
|
