what is a formula

[4pinoy]

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.

 

[Don Guillett]

Troll?

 

[4pinoy]

You can post your question on another thread, I need answer not a question.
sincerely...

Troll?

 

[joeu2004]

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.

 

[4pinoy]

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 ?

 

[4pinoy]

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

 

[joeu2004]

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.

 

[joeu2004]

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.

 

[driller]

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....

 

[4pinoy]

thanks anyway...
I never intend to grind any axe as it may sound to you....this is a thread
in question...

 

[joeu2004]

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....

It was an error in a Help page -- that is, Help > Excel Help (with
Online Content disabled).

 

[Chip Pearson]

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...

The documentation for the TYPE funtion used to say that you could detect
whether a cell contained a formula, if TYPE returned either 8 or 32 (I
think). That never worked, so they changed the help file instead of fixing
the problem.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)