Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 5th March 2006, 01:24 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Question Excel help please??

Could anyone point me in the right direction?

I need a formula for the following! I have 3 columns with the 3 different state divs in them. In the fourth column I want to put the highest div of the 3 columns. Of course in some cases the three divs could be all the same. Anybody have any suggestions it would be greatly appreciated.

Thanks
Twodogs
Reply With Quote
  #2  
Old 5th March 2006, 01:44 PM
La Mer La Mer is offline
Member
 
Join Date: Jan 1970
Posts: 578
Default

Quote:
Originally Posted by Twodogs
Could anyone point me in the right direction?

I need a formula for the following! I have 3 columns with the 3 different state divs in them. In the fourth column I want to put the highest div of the 3 columns. Of course in some cases the three divs could be all the same. Anybody have any suggestions it would be greatly appreciated. Thanks Twodogs


Assuming you have columns A B C D, with cell A1 containing 4.30 B1 containing 4.6 & C1 containing 4.20 then in column D1 place the following formula:
=MAX(A1:C1)

That should do it with the answer being 4.6 being shown in cell D1.
Reply With Quote
  #3  
Old 5th March 2006, 01:45 PM
wesmip1 wesmip1 is offline
Member
 
Join Date: Sep 2005
Posts: 1,601
Default

use MAX(CELL1:CELLn)

where CELL1 is the first column an CELLn is the last column.

Seemed to work for me.

Good Luck.
Reply With Quote
  #4  
Old 5th March 2006, 01:46 PM
wesmip1 wesmip1 is offline
Member
 
Join Date: Sep 2005
Posts: 1,601
Default

Ahh and I see La Mer just beat me to it ....
Reply With Quote
  #5  
Old 5th March 2006, 01:51 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Thanks for that!!

What if the columns were not side by side?? Say column A, C and E

Twodogs
Reply With Quote
  #6  
Old 5th March 2006, 01:56 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Thumbs up

I think I worked it out!!!

=MAX(A534,C534,E534)

Twodogs

Thanks again for your help!!!

Last edited by Twodogs : 5th March 2006 at 02:05 PM. Reason: A thank you
Reply With Quote
  #7  
Old 7th March 2006, 12:36 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Question

Any ideas on how I can overcome getting an answer #DIV/0! I am using the following formula but the problem is that some of the data is zeros and I get the answer #DIV/0! when it it (0/0)*100.

=('Full Fields'!BZ7/'Full Fields'!BY7)*100

Is there an alternative formula that I could use to overcome this?

Thanks
Twodogs
Reply With Quote
  #8  
Old 7th March 2006, 12:47 PM
wesmip1 wesmip1 is offline
Member
 
Join Date: Sep 2005
Posts: 1,601
Default

A simple If soles the problem :


=IF('Full Fields'!BY7 = 0, 0, ('Full Fields'!BZ7/'Full Fields'!BY7)*100)

Good Luck,
Reply With Quote
  #9  
Old 7th March 2006, 12:49 PM
davez davez is offline
Member
 
Join Date: Jan 1970
Posts: 301
Default

=IF(ISERROR('Full Fields'!BZ7/'Full Fields'!BY7)*100,0,'Full Fields'!BZ7/'Full Fields'!BY7*100)


should do it
Reply With Quote
  #10  
Old 7th March 2006, 12:55 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Thanks Guys

You certainly know your excel. I am learning but slowly.

Cheers
Twodogs
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 01:55 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655