ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas (https://www.excelbanter.com/excel-worksheet-functions/9548-formulas.html)

Stan

Formulas
 
Could anyone please provide a little help?
I have, after a lot of effort and fact finding on this group & the net
managed to sort out 2 simple formulas to provide subtotals and a totals
entry in a excel document.
However, despite all my searching, I have been unable to find and list or
general rules of standard formulas available, which I can use to cover most
circumstances.
What I have seen so far is specific formulas for specific problems, yet
surely there must be a list of basic formula rules, pre-made formulas or
even a simple beginners guide of "how to create formulas"
If anyone knows of such a list or a link to a website where such info is
available, I would be very grateful.

Cheers

Stan




Bob Phillips

Stan,

Peter Nonely has a nice workbook for this that you can get at Ron de Bruin's
site at http://www.rondebruin.nl/id.htm. Scroll down to the bottom

--
HTH

Bob Phillips

"Stan" wrote in message
...
Could anyone please provide a little help?
I have, after a lot of effort and fact finding on this group & the net
managed to sort out 2 simple formulas to provide subtotals and a totals
entry in a excel document.
However, despite all my searching, I have been unable to find and list or
general rules of standard formulas available, which I can use to cover

most
circumstances.
What I have seen so far is specific formulas for specific problems, yet
surely there must be a list of basic formula rules, pre-made formulas or
even a simple beginners guide of "how to create formulas"
If anyone knows of such a list or a link to a website where such info is
available, I would be very grateful.

Cheers

Stan






Stan

Cheers for that link.

But I downloaded the Excel Function Dictionary but didn't see any relevant
info there.
Have I got the wrong file or am I as stupid as I feel right now?

Stan



"Bob Phillips" wrote in message
...
Stan,

Peter Nonely has a nice workbook for this that you can get at Ron de
Bruin's
site at http://www.rondebruin.nl/id.htm. Scroll down to the bottom

--
HTH

Bob Phillips

"Stan" wrote in message
...
Could anyone please provide a little help?
I have, after a lot of effort and fact finding on this group & the net
managed to sort out 2 simple formulas to provide subtotals and a totals
entry in a excel document.
However, despite all my searching, I have been unable to find and list or
general rules of standard formulas available, which I can use to cover

most
circumstances.
What I have seen so far is specific formulas for specific problems, yet
surely there must be a list of basic formula rules, pre-made formulas or
even a simple beginners guide of "how to create formulas"
If anyone knows of such a list or a link to a website where such info is
available, I would be very grateful.

Cheers

Stan








Bob Phillips

Stan,

Re-reading your post, I think I didn't quite understand what you wanted.

I thought you wanted details of the built-in formulas, I now believe you are
asking for formulas for standard problems, that it maybe incorporating many
functions. If so, what defines standard? I don't think anyone has attempted
to do that.

--
HTH

Bob Phillips

"Stan" wrote in message
...
Cheers for that link.

But I downloaded the Excel Function Dictionary but didn't see any relevant
info there.
Have I got the wrong file or am I as stupid as I feel right now?

Stan



"Bob Phillips" wrote in message
...
Stan,

Peter Nonely has a nice workbook for this that you can get at Ron de
Bruin's
site at http://www.rondebruin.nl/id.htm. Scroll down to the bottom

--
HTH

Bob Phillips

"Stan" wrote in message
...
Could anyone please provide a little help?
I have, after a lot of effort and fact finding on this group & the net
managed to sort out 2 simple formulas to provide subtotals and a totals
entry in a excel document.
However, despite all my searching, I have been unable to find and list

or
general rules of standard formulas available, which I can use to cover

most
circumstances.
What I have seen so far is specific formulas for specific problems, yet
surely there must be a list of basic formula rules, pre-made formulas

or
even a simple beginners guide of "how to create formulas"
If anyone knows of such a list or a link to a website where such info

is
available, I would be very grateful.

Cheers

Stan











All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com