![]() |
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 |
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 |
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 |
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