Dear all
Greetings!
B, C, D, E, F, G, H and I, have a percentage values in left side of attached table. The A is number of days which is common for all B to I.
The right side table in yellow colored is a result of day which is 10% and 90% of every stage.
The yellow colored result is calculated manually. For example: If I need to find a 10% and 90% values at A for B, I have used following formula: "A7+(A8-A7)/(SUM (B7:B8)/10)/100" and "A24+(A25-A24)/(SUM(B24:B25)/90)/100" to get the actual day from A.
I have use similar formula to all stage. But doing manually is a very lengthy process. My question is: Can anyone know how to I fixed the formula in excel sheets? And it is easy to get result in same time when I put values in B3 to I31.
Enter "=B2/10" and "=B2*0.9" on cell K2 and L2 respectively.
Check the attachment. I believe this is what you are looking for.
Regards
Janardhan TS
Bengaluru
Dear @Janardhan T S, Thank you very much for your reply but your answer is not correct what I am thinking to. You can see case A in my excel sheet what i am thinking to get. My answer should be choose from row A of 10% and 90% of B, C, or I.
Regards
Digambar
Digambar Singh Dahal, as I understood, you need to detect the days when the percentage values exceed 10% and 90% respectively and create appropriate values for data for those days, right? If so, I guess you will need some formula using the VLOOKUP function (the search in a range of cells). Please confirm, then I'll try to help you.
Dear @Przemyslaw Kowalik, Yes you are right I want to detect the days when the percentage values are 10% and 90%, likewise if the percentage values of B or C or D etc have minimum value 0 to 11% or 5% to 20%, or any how to find days in 10% in between them. for days in 90%: if the percentage value is between maximum 0 to 91% or 85 to 98%or 70% to 100% etc, How do I also detect 90% value in A (days)?
I hope you can understand my question now.
My solution is attached.
The key element is to extract the portion of the B/C/.../I column where values are increasing. Your examples show that you're taking values not from the whole column, but only from that portion.
Otherwise, the solution is trivial: it finds the first element which is larger than 10 (or 90 or whatever is the parameter) and inputs that cell and the cell directly above it in your formula.
Dear@Alexander Tarvid, Thank you very much for your solution to my question but I did not get actual result to every time if I put different values in B3 to I31. You can look my attached excel sheet "Case A(2)". If possible you can work on "Case B" which is a value without percentages. Result should not be exceeded more than or below 10% or 90%. it should be exact 10% or 90%
Regards
Digambar
Please find my attached solution, as your formulas were not correct.
Dear @ Mohammad N. Elnesr
Why H(10%) has no values in attached excel sheet? If it is 10% or 90% its should be exact value. my manual work was: for 10%: I added minimum 10% and Max10% and divided it by 10% i.e; (B7+B8) = (B7+B8)/10, used that product to divide difference of (A8-A7) and add it to A7 which is 10% values in A of B. Same method used for 90% too. If my prediction is mathematically not suitable for , I hope to follow your instruction. I hope to get your correction soon.
Attached is the corrected sheet,
The error was at the comparison operator, it should be >= instead of > only.
Regards.
Dear@Mohammad N. Elnesr, it works now thank you very much.
Regards
Digambar
Dear @Mohammad N. Elnesr, The formula you have suggested is working on my all variables but there is one issues arose that: what should be done if the minimum value is more than 10%?
Mathematically, it is not possible to guarantee a correct solution. The computer can solve it only if you can manually tell it what to do.
If the 130 is the actual minimum of the data, then the solution should be (
Dear@Mohammad N. Elnesr, Thank you very much for your reply..
Regards
Digambar
- Badges
- Science topic