Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Cashtime
 
Posts: n/a
Default Excel formula similar to a loop in Basic?

Can anyone please tell me the Excel formula structure that would give values
similar to a FOR TO loop in Basic? It's for soccer results. At the moment I
update the win, draw, and lost totals manually at the end of each column and
row.
e.g.....
For n=1 to 8
If goalsfor(n) goalsagainst(n) then win=win+1
If goalsfor(n) = goalsagainst(n) then draw=draw+1
If goalsfor(n) < goalsagainst(n) then lost=lost+1
Next n
So, I need a formula that will return the values of Win, Draw, and Lost :-)
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

A bit difficult to judge from here. But probably you can use the DataTable
command. Look in HELP for details.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Cashtime" wrote in message
...
Can anyone please tell me the Excel formula structure that would give
values
similar to a FOR TO loop in Basic? It's for soccer results. At the moment
I
update the win, draw, and lost totals manually at the end of each column
and
row.
e.g.....
For n=1 to 8
If goalsfor(n) goalsagainst(n) then win=win+1
If goalsfor(n) = goalsagainst(n) then draw=draw+1
If goalsfor(n) < goalsagainst(n) then lost=lost+1
Next n
So, I need a formula that will return the values of Win, Draw, and Lost
:-)



  #3   Report Post  
Cashtime
 
Posts: n/a
Default

Thanks Niek. After looking deeply into Help, it looks like Array formulas may
be the solution. I'll let you know if they are!

"Niek Otten" wrote:

A bit difficult to judge from here. But probably you can use the DataTable
command. Look in HELP for details.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Cashtime" wrote in message
...
Can anyone please tell me the Excel formula structure that would give
values
similar to a FOR TO loop in Basic? It's for soccer results. At the moment
I
update the win, draw, and lost totals manually at the end of each column
and
row.
e.g.....
For n=1 to 8
If goalsfor(n) goalsagainst(n) then win=win+1
If goalsfor(n) = goalsagainst(n) then draw=draw+1
If goalsfor(n) < goalsagainst(n) then lost=lost+1
Next n
So, I need a formula that will return the values of Win, Draw, and Lost
:-)




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel version identification from Visual Basic Raja Ranga Excel Discussion (Misc queries) 6 January 17th 05 09:48 PM
Throubles with Visual Basic and Excel Matias Excel Worksheet Functions 1 December 31st 04 12:27 AM
Preserve Excel formula entry MHoffmeier Excel Discussion (Misc queries) 5 December 2nd 04 07:34 PM
Suddenly Excel can't calculate formula!!! Bob H Excel Worksheet Functions 2 November 30th 04 09:35 PM
Excel Time Duration Formula Jackson Excel Worksheet Functions 2 November 5th 04 12:14 AM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"