ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i get a list of different formulas (https://www.excelbanter.com/excel-worksheet-functions/19095-how-do-i-get-list-different-formulas.html)

CHICOALLEN

how do i get a list of different formulas
 
i need to find a list of excel formulas and there different functions within
a worksheet

Bob Phillips

See Peter Nonely's downloadable Functions workbook at Ron de Bruin's site.


http://www.rondebruin.nl/id.ht*m


--

HTH


RP
(remove nothere from the email address if mailing direct)


"CHICOALLEN" wrote in message
...
i need to find a list of excel formulas and there different functions

within
a worksheet




chicoallen

that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions within
a worksheet


Bob Phillips

I just pasted it into the URL bar and it added a - into the htm, make sure
you see htm, not ht-m

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet




chicoallen

i need to know how to find what this and other functions do (='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions within
a worksheet


N Harkawat

Take a look at
http://www.contextures.com/tiptech.html


"chicoallen" wrote in message
...
that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions
within
a worksheet




chicoallen

thank you for your help but the htm address still wont work any suggestions??
there is no ht-m just htm

"chicoallen" wrote:

i need to know how to find what this and other functions do (='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions within
a worksheet


Bob Phillips

Nope, I can get it okay, just tried.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
thank you for your help but the htm address still wont work any

suggestions??
there is no ht-m just htm

"chicoallen" wrote:

i need to know how to find what this and other functions do (='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet




Bob Phillips

That looks up the value in a sheet name 1, cell F2, and adds 1 to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
i need to know how to find what this and other functions do (='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet




chicoallen

thank you that link came up just fine and i hope it cane help this rookie



:)

"N Harkawat" wrote:

Take a look at
http://www.contextures.com/tiptech.html


"chicoallen" wrote in message
...
that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions
within
a worksheet





chicoallen

thanks for all of your help bob
you are an asset to all rookies

"Bob Phillips" wrote:

That looks up the value in a sheet name 1, cell F2, and adds 1 to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
i need to know how to find what this and other functions do (='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet





Bob Phillips

I wish you could get to Ron's site though, as that workbook is very good. If
you send me your email, I will mail it to you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
thanks for all of your help bob
you are an asset to all rookies

"Bob Phillips" wrote:

That looks up the value in a sheet name 1, cell F2, and adds 1 to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
i need to know how to find what this and other functions do

(='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different

functions
within
a worksheet







Dave Peterson

Ron de Bruin has a copy (from an earlier post):

Take a look at Peter Nonely's workbook that describes lots of functions:
http://homepage.ntlworld.com/noneley/

If Peter's site isn't working, but Ron deBruin has a copy at:
http://www.rondebruin.nl/files/xlfdic01.zip



Bob Phillips wrote:

See Peter Nonely's downloadable Functions workbook at Ron de Bruin's site.

http://www.rondebruin.nl/id.ht*m

--

HTH

RP
(remove nothere from the email address if mailing direct)

"CHICOALLEN" wrote in message
...
i need to find a list of excel formulas and there different functions

within
a worksheet


--

Dave Peterson

Bob Phillips


"Dave Peterson" wrote in message
...

Take a look at Peter Nonely's workbook that describes lots of functions:
http://homepage.ntlworld.com/noneley/


Peter's page no longer exists.

If Peter's site isn't working, but Ron deBruin has a copy at:
http://www.rondebruin.nl/files/xlfdic01.zip


Which is the download file linked to on the page I gave.

Bob Phillips wrote:

See Peter Nonely's downloadable Functions workbook at Ron de Bruin's

site.

http://www.rondebruin.nl/id.ht*m




Ron de Bruin

We love the Google Beta Bob<g


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message ...
I just pasted it into the URL bar and it added a - into the htm, make sure
you see htm, not ht-m

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet






Ron de Bruin

Dave's download link is working and this one also

http://www.rondebruin.nl/id.htm
On the bottom of the page



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message ...
I wish you could get to Ron's site though, as that workbook is very good. If
you send me your email, I will mail it to you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
thanks for all of your help bob
you are an asset to all rookies

"Bob Phillips" wrote:

That looks up the value in a sheet name 1, cell F2, and adds 1 to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
i need to know how to find what this and other functions do

(='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different

functions
within
a worksheet








Bob Phillips

Don't we just - yuuk! :-)

Regards

Bob


"Ron de Bruin" wrote in message
...
We love the Google Beta Bob<g


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message

...
I just pasted it into the URL bar and it added a - into the htm, make

sure
you see htm, not ht-m

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
that link is showing not a valid address

"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different functions

within
a worksheet








Bob Phillips

They both work for me Ron, the OP either got it wrong or has another
problem.

Regards

Bob


"Ron de Bruin" wrote in message
...
Dave's download link is working and this one also

http://www.rondebruin.nl/id.htm
On the bottom of the page



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message

...
I wish you could get to Ron's site though, as that workbook is very good.

If
you send me your email, I will mail it to you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
thanks for all of your help bob
you are an asset to all rookies

"Bob Phillips" wrote:

That looks up the value in a sheet name 1, cell F2, and adds 1 to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"chicoallen" wrote in message
...
i need to know how to find what this and other functions do

(='1'!F2+1)


"CHICOALLEN" wrote:

i need to find a list of excel formulas and there different

functions
within
a worksheet











All times are GMT +1. The time now is 04:16 AM.

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