I am setting up a market timing study in excel and I'm having difficulty with the following:
In column c I have many rows of numbers ranging from 0 to 5. These determine if I'm long (invested) in the security or neutral (cash). For example I start long and stay long many days until a cell in...
Complicated but... here's the final product I need:
Bold = data I have
non-bold = data how I need it to show
<tbody>
Customer A
Customer B
20
120
Product 1
10
10
Product 2
10
10
Product 3
80
80
Product 4
10
10
Product 5
10
10
Product 6
10
10
Product 7
10
10...
Hi I have a complicated index and match formula but I cannot figure out how to add a partial text search to it. Eg how do I add search for "apple*" without an array.
thank you.....here is the current formula. alex...
Good Morning All
I have a datasheet that looks at health interventions in an organisation.
A data feed I receive populates the datasheet with the dates on which these interventions happen and I calculate the next due date of the intervention for an individual - nothing complicated, quite...
Hi,
I'm wondering if we can make this Multiple IF Statement a less complicated one.
=if(J2="Free Minutes - New Client/Welcome Email",0,
if(J2="Free Minutes - Payoff/Bonus", 0,
if(J2="Internal - Not Billed",0,
if(J2="Billed Minutes - Peak", H2*0.25,
if(J2="Billed Minutes -...
I have a spreadsheet with a column of formulae, like this example:
=HYPERLINK("http...." & C2, left(B2,8))
Now let's say that formula is in cell D2. If I then go elsewhere on my spreadsheet and enter the formula =D2, all I get is plain text of the friendly name (argument 2 of the HYPERLINK...
I have a large spreadsheet with 14 different conditional formatting rules. I'm tired of having to weed them out everytime I blink. If I did it with VBA would it eliminate that problem? If so I would like to do that. I can likely figure out how to set up most if not all of them once I have...
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hello I would love any assistance on this, I've spent hours trying to solve this. Thank you in advance for taking any time to help.
The result I would like
I type in a name and date of...
I need the percentages of values where it is greater than or equal to 0, however, for each column the value is different and to get the values I have used an index match formula so all cells have a formula which is causing the issues.
So far I have tried...
Hi
I want do check student marks and based on the value I will make excel to type a,b,c,d,f.
If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier...
Hi... I'm new here and I do Graphic Design.
Does anyone know of a formula I can use for a commission structure?
Whatever the cost to print is, I need a formula that looks at the value in that cell and calculates the correct commission flat rate or percentage in the commission cell.
Printing...
I went through some Index and Sumproduct solutions with AhoyNC in this thread:
https://www.mrexcel.com/forum/excel-questions/1060891-using-vlookup-check-date-against-date-range-return-value-2.html#post5095694
But ultimately my data table is too big (last post in thread has a URL) and...
Looking for some help with a complicated formula to corrilate with 3 sheets. I would have to email someone the file to see what I am needing. I've been trying to figure this out for some time. Anyone can help please send me your email address or a way I can send you the Excel file. Thanks!
Respected,
was showing Error code 0-1012 (0)
So as per microsoft recommendations disable
1)Antivirus
2)firewall
3)empty temporary files
4)Make mare diskspace(previously was 148 GB , now is 162 GB)
Now only one issue is left , repair registry(and that needs reinstalling which is a very...
Hi all,
I need to know if theres a way you can make a formula for the parameters below-
Plus 9 except when reaching a multiple of 10, then plus 10 then plus 19 then carry on with plus 9.
For example-
12512, 12521, 12530, 12540, 12559, 12568, 12577.
Many thanks if this can be done! Don't...
Hey,
Quick question, how do I create a selection box (small size) that will go from red to green when its checked off.
if this is going to be too complicated then i will let it be.
Thanks for the help,
Sam
Just out of curiosity, is there an easier way to do this equation? Meaning, can I simplify this equation to any degree?
The order of the columns must stay the same, sorry...
Hi,
I am looking for a way to notify me of any date that exceeds todays date by 2 days
If at all possible I would like week days only, but not sure if this is too complicated
Many thanks
Hello. Below is a not too terribly complicated nested if statement:
=IF(AND(D2>=55000,D2<=66000),IF(AND(C2="A"),K148,IF(AND(C2="B"),K149,IF(AND(C2="C"),K150,IF(AND(C2="D"),K151,IF(AND(C2="E"),K152,IF(AND(C2="F"),K153,0)))))))
What I need to do now is to nest two other nearly identical formulas...
Hello everyone,
I have decided to take my confusion to the forums, though I've never done this before, so I will do all that I can to make this as least painful as possible, and if I don't follow protocol exactly, I am deeply sorry- I am doing my best.
I am documenting sales velocity of...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.