-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
900
-
F
SUMPRODUCT - IF statement in array
Hello Community, I've been stumped with a question for a bit while using a SUMPRODUCT. Below I have a fairly simple of example of what I want to accomplish. If the stock price ($20) is greater than the strike price, I want to take the difference and multiply it by the units. If I have a stock...- fun2excel4money
- Thread
- 000.00 100 900 price units
- Replies: 8
- Forum: Excel Questions
-
E
Offset + Dynamic Index / Match
Hi, Ive been working on a a dynamic INDEX / MATCH, which I've sovled. How ever the values I'm returning on not always unique, and I want to lookup other values from the same column/row. <!--[if !mso]><style>v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}x\:*...- Eyeope
- Thread
- 200 900 chris marketing values
- Replies: 22
- Forum: Excel Questions
-
D
Help calculate contractor costs by months or quarters
Hi. I'm trying to write a formula to calculate the cost of various employees spread over months (or quarters) so I can create graphs of the annual cost impact to a business. They all have different contract start and end dates along with varying daily rates of pay. Can anyone help me please? If...- Des66
- Thread
- 000 600 900
- Replies: 3
- Forum: Excel Questions
-
S
Values with spaces
I have a list of amount but it contained spaces before and after figures how can I get only numerical value. like 100,000 78,900 23,000- Salamullah
- Thread
- 000 900 figures numerical spaces
- Replies: 15
- Forum: Excel Questions
