If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what is a formula
I have to re post and clarify my yesterdays question.... "A ? for our Excel Guru's and MVP's" : I request the current MVP to place the appropriate Check mark on the only correct replies. Here it goes.... Considering that we are under the Microsoft Forum Domain and as a simple excel user. I need to know what are the guarantee we can obtain from 3rd party Add Ins or formula building in standard excel program considering the following. 1. Excel program always upgrade itself..Will the suggested formula building thru 3rd party suggestions be an integral part of any excel upgrade? 2. If there are formula suggested under this forum that are not covered by the Help Files samples and Function description, will this microsoft forum guarantee the CHECKED MARKS and such checked marks will be integral to all the succeeding microsoft Upgrades. I am not foolish to follow any answer or suggestion even they are CHECKED if these replies are not explained or distinguished precisely by microsoft help files considering a risk in the future that I may not able to use the old MS files, utilizing unexplained formula structuring by the excel programmers himself or MS Support / help files. I hope you can bother to give clarity since my and your excel's future is based on the present - the spreadsheet you are now building. We are always trying to synchronize the MS products and avoiding any future conflict with each other program...(i.e. ms word, ms. access, etc.). Now, As an extension...Since the microsoft forum have duly selected the technical expertise of our MVP's...I am looking forward that microsoft excel will provide these formula structuring (function usage) in the microsoft Help or support Files...further to allowing our dear users like me to use such in a recorded excel files....that must be integral with the rest of MS programs. I am not questioning about all of the ms products...I am pertaining only on the formula structuring of excel thru this forum - no more no less. Since I use excel, I hade never experienced a fault on formula structuing guided by the help files...I consider the help files as a true guarantee on a cautiously made spreadsheet.. Out from the help files,,,I cannot do it with risk. Also see : https://mvp.support.microsoft.com/mvptechres I've scanned thru the above site and found out the certifications / licensing / opportunities / rights / entitlements for MVP directly. Hence I suppose that all of checked suggestions are responsive and linked with microsoft excel formula structuring, integral with ms products. You can also see from other page where the forum's page with rules of conduct and other matters about microsoft role on this forum together with MVP's who can control the forum in checking and unchecking....It is usual to find replies from the MVP's. Now, i dont know if you can still see all tags beside their signature reply). I hope that everything is linked together, same with the basics of excel formula structuring along with the other MS programs. Thanks to the following for sharing their views yesterday... Dave F , Don Guillett , Bob Phillips, Jim Thomlinson, Ron Rosenfeld, Gord Dibben, Biff, Epinn, CLR My questions are still unchecked. In reference to the base role of this MS forum. and Controlling power of our helpful MVPs for this Forum.... 1. if 3rd party is not a part of excel's formula building, then why include it as a link answer, a suggestion and even check it ? 2. Can a bug be possibly created by a formula or by a macro ? 3. Can a formula structure that is not within the base structure/criterias defined in Fx , Help files...be pronounced by an MVP as an answer ? Looking to find a reply and another counter check by at least 2 MVPs. sincere thanks to all. -- An ounce of prevention is worth a pound of cure! |
#3
|
|||
|
|||
what is a formula
You can post your question on another thread, I need answer not a question.
sincerely... "Don Guillett" wrote: Troll? -- Don Guillett SalesAid Software "4pinoy" wrote in message ... I have to re post and clarify my yesterdays question.... "A ? for our Excel Guru's and MVP's" : I request the current MVP to place the appropriate Check mark on the only correct replies. Here it goes.... Considering that we are under the Microsoft Forum Domain and as a simple excel user. I need to know what are the guarantee we can obtain from 3rd party Add Ins or formula building in standard excel program considering the following. 1. Excel program always upgrade itself..Will the suggested formula building thru 3rd party suggestions be an integral part of any excel upgrade? 2. If there are formula suggested under this forum that are not covered by the Help Files samples and Function description, will this microsoft forum guarantee the CHECKED MARKS and such checked marks will be integral to all the succeeding microsoft Upgrades. I am not foolish to follow any answer or suggestion even they are CHECKED if these replies are not explained or distinguished precisely by microsoft help files considering a risk in the future that I may not able to use the old MS files, utilizing unexplained formula structuring by the excel programmers himself or MS Support / help files. I hope you can bother to give clarity since my and your excel's future is based on the present - the spreadsheet you are now building. We are always trying to synchronize the MS products and avoiding any future conflict with each other program...(i.e. ms word, ms. access, etc.). Now, As an extension...Since the microsoft forum have duly selected the technical expertise of our MVP's...I am looking forward that microsoft excel will provide these formula structuring (function usage) in the microsoft Help or support Files...further to allowing our dear users like me to use such in a recorded excel files....that must be integral with the rest of MS programs. I am not questioning about all of the ms products...I am pertaining only on the formula structuring of excel thru this forum - no more no less. Since I use excel, I hade never experienced a fault on formula structuing guided by the help files...I consider the help files as a true guarantee on a cautiously made spreadsheet.. Out from the help files,,,I cannot do it with risk. Also see : https://mvp.support.microsoft.com/mvptechres I've scanned thru the above site and found out the certifications / licensing / opportunities / rights / entitlements for MVP directly. Hence I suppose that all of checked suggestions are responsive and linked with microsoft excel formula structuring, integral with ms products. You can also see from other page where the forum's page with rules of conduct and other matters about microsoft role on this forum together with MVP's who can control the forum in checking and unchecking....It is usual to find replies from the MVP's. Now, i dont know if you can still see all tags beside their signature reply). I hope that everything is linked together, same with the basics of excel formula structuring along with the other MS programs. Thanks to the following for sharing their views yesterday... Dave F , Don Guillett , Bob Phillips, Jim Thomlinson, Ron Rosenfeld, Gord Dibben, Biff, Epinn, CLR My questions are still unchecked. In reference to the base role of this MS forum. and Controlling power of our helpful MVPs for this Forum.... 1. if 3rd party is not a part of excel's formula building, then why include it as a link answer, a suggestion and even check it ? 2. Can a bug be possibly created by a formula or by a macro ? 3. Can a formula structure that is not within the base structure/criterias defined in Fx , Help files...be pronounced by an MVP as an answer ? Looking to find a reply and another counter check by at least 2 MVPs. sincere thanks to all. -- An ounce of prevention is worth a pound of cure! |
#4
|
|||
|
|||
what is a formula
4pinoy wrote:
1. Excel program always upgrade itself..Will the suggested formula building thru 3rd party suggestions be an integral part of any excel upgrade? You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums. 2. If there are formula suggested under this forum that are not covered by the Help Files samples and Function description, will this microsoft forum guarantee the CHECKED MARKS and such checked marks will be integral to all the succeeding microsoft Upgrades. I do not know what "checked marks" you are referring to. But generally, nothing posted in these forums is guaranteed to work even for the current suite of MS products, much less any future upgrades. I am not questioning about all of the ms products...I am pertaining only on the formula structuring of excel thru this forum - no more no less. Formulas and solutions posted in this forum carry no guanantee or warranty, unless expressly offered by the person posting them (and believe me, that is never!). The content of these forums is not provided, scrutinized or authorized by Microsoft. They are provided by individuals with widely varying expertise -- both professional and non-professional. The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts. I consider the help files as a true guarantee Even for Microsoft products, I am reasonably sure that statements made in Help pages are not intended to "guarantee" anything. (Disclaimer: I do not work for MS, and I do not speak for them.) I cannot do it with risk. Then do not rely on any information posted in these forums. |
#5
|
|||
|
|||
what is a formula
thanks joeu.....
Here I go again to re-quote... "Since I use excel, I hade never experienced a fault on formula structuing guided by the help files...I consider the help files as a true guarantee on a cautiously made spreadsheet.. Out from the help files,,,I cannot do it with risk" Now please comment herebelow 1.Do you have even a single experience on a wrong formula structure building based from the help files of when you click the Fx button ? If you do, please share to us... are you still there to reply ? -- An ounce of prevention is worth a pound of cure! " wrote: 4pinoy wrote: 1. Excel program always upgrade itself..Will the suggested formula building thru 3rd party suggestions be an integral part of any excel upgrade? You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums. 2. If there are formula suggested under this forum that are not covered by the Help Files samples and Function description, will this microsoft forum guarantee the CHECKED MARKS and such checked marks will be integral to all the succeeding microsoft Upgrades. I do not know what "checked marks" you are referring to. But generally, nothing posted in these forums is guaranteed to work even for the current suite of MS products, much less any future upgrades. I am not questioning about all of the ms products...I am pertaining only on the formula structuring of excel thru this forum - no more no less. Formulas and solutions posted in this forum carry no guanantee or warranty, unless expressly offered by the person posting them (and believe me, that is never!). The content of these forums is not provided, scrutinized or authorized by Microsoft. They are provided by individuals with widely varying expertise -- both professional and non-professional. The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts. I consider the help files as a true guarantee Even for Microsoft products, I am reasonably sure that statements made in Help pages are not intended to "guarantee" anything. (Disclaimer: I do not work for MS, and I do not speak for them.) I cannot do it with risk. Then do not rely on any information posted in these forums. |
#6
|
|||
|
|||
what is a formula
Sorry joeu, i forgot to reflect your other answer.
1. "You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums." - Wouldn't it be correct that the person who gave the link answer be honest enough to know first the above quotes before suggesting it especially to a new excel user ? 2. "The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts." I am not saying that MVP must guarant or warrant the answer. I will repeat your quote such as "The "MVP" designation, if used responsibly". Also please see for your background info and please read it between the lines, maybe you will be amazed: https://mvp.support.microsoft.com/mvptechres -- An ounce of prevention is worth a pound of cure! " wrote: 4pinoy wrote: 1. Excel program always upgrade itself..Will the suggested formula building thru 3rd party suggestions be an integral part of any excel upgrade? You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums. 2. If there are formula suggested under this forum that are not covered by the Help Files samples and Function description, will this microsoft forum guarantee the CHECKED MARKS and such checked marks will be integral to all the succeeding microsoft Upgrades. I do not know what "checked marks" you are referring to. But generally, nothing posted in these forums is guaranteed to work even for the current suite of MS products, much less any future upgrades. I am not questioning about all of the ms products...I am pertaining only on the formula structuring of excel thru this forum - no more no less. Formulas and solutions posted in this forum carry no guanantee or warranty, unless expressly offered by the person posting them (and believe me, that is never!). The content of these forums is not provided, scrutinized or authorized by Microsoft. They are provided by individuals with widely varying expertise -- both professional and non-professional. The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts. I consider the help files as a true guarantee Even for Microsoft products, I am reasonably sure that statements made in Help pages are not intended to "guarantee" anything. (Disclaimer: I do not work for MS, and I do not speak for them.) I cannot do it with risk. Then do not rely on any information posted in these forums. |
#7
|
|||
|
|||
what is a formula
4pinoy wrote:
Now please comment herebelow 1.Do you have even a single experience on a wrong formula structure building based from the help files of when you click the Fx button ? If you do, please share to us... are you still there to reply ? Actually, now that you mention it, yes(!). A Help page explained the operation of the function as just the opposite of what it actually does. Sorry, I cannot remember which one. If you really need to know, you might search for my postings month or so. I'm pretty sure I made a note of it recently. It might have been one of the rounding or truncation functions. The error is an obvious cut-and-paste error on the part of the writer. It did not cause me "a wrong formula structure building" because I recognized the obvious error. |
#8
|
|||
|
|||
what is a formula
4pinoy wrote:
Sorry joeu, i forgot to reflect your other answer. "You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums." - Wouldn't it be correct that the person who gave the link answer be honest enough to know first the above quotes before suggesting it especially to a new excel user ? No: that is an unreasonable expectation. People make only a "best effort" at offering assistance. "The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts." I am not saying that MVP must guarant or warrant the answer. I will repeat your quote such as "The "MVP" designation, if used responsibly". By that, I meant: you really have no way to know for sure that someone is who they say they are. That is the reality of the "anonymous" Internet. Also please see for your background info and please read it between the lines, maybe you will be amazed: https://mvp.support.microsoft.com/mvptechres What does that web page have to do with "the price of tea in China"? That web page has to do with services that Microsoft provides to MVPs. But I thought you were asking about how much you can rely on the postings in these forums and on Help pages and files. It sounds like you have an axe to grind. I will leave you to resolve your issues on your own. |
#9
|
|||
|
|||
what is a formula
joeu....is the error you found in the excel Fx Function Argument pop-up
window where you can input the cell refs or values? Or is it a typo error in help file documentation ? pls. clarify.... -- An ounce of prevention is worth a pound of cure! " wrote: 4pinoy wrote: Now please comment herebelow 1.Do you have even a single experience on a wrong formula structure building based from the help files of when you click the Fx button ? If you do, please share to us... are you still there to reply ? Actually, now that you mention it, yes(!). A Help page explained the operation of the function as just the opposite of what it actually does. Sorry, I cannot remember which one. If you really need to know, you might search for my postings month or so. I'm pretty sure I made a note of it recently. It might have been one of the rounding or truncation functions. The error is an obvious cut-and-paste error on the part of the writer. It did not cause me "a wrong formula structure building" because I recognized the obvious error. |
#10
|
|||
|
|||
what is a formula
thanks anyway...
I never intend to grind any axe as it may sound to you....this is a thread in question... " wrote: 4pinoy wrote: Sorry joeu, i forgot to reflect your other answer. "You would have to ask the supplier ("3rd party"). Generally, there is no such warranty, especially with any formula or solution posted in these forums." - Wouldn't it be correct that the person who gave the link answer be honest enough to know first the above quotes before suggesting it especially to a new excel user ? No: that is an unreasonable expectation. People make only a "best effort" at offering assistance. "The "MVP" designation, if used responsibly, only indicates that the person has certain qualifications. It does not mean that person is all-knowing or infallible; and it does not imply a guarantee or warranty of anything that an "MVP" posts." I am not saying that MVP must guarant or warrant the answer. I will repeat your quote such as "The "MVP" designation, if used responsibly". By that, I meant: you really have no way to know for sure that someone is who they say they are. That is the reality of the "anonymous" Internet. Also please see for your background info and please read it between the lines, maybe you will be amazed: https://mvp.support.microsoft.com/mvptechres What does that web page have to do with "the price of tea in China"? That web page has to do with services that Microsoft provides to MVPs. But I thought you were asking about how much you can rely on the postings in these forums and on Help pages and files. It sounds like you have an axe to grind. I will leave you to resolve your issues on your own. |
|
Thread Tools | |
Display Modes | |
|
|