OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - excel help (http://forums.ozmium.com.au/showthread.php?t=14971)

ingust

12th November 2006 12:15 PM

excel help

Hi all
can anyone help me place the following in an EXCEL single cell if possible ,

if b1 = < 1250 then divisor = 4 , if b1 = > 1251 and b1 = < 1450 then divisor=3 , if b1 = > 1451 and b1 = < 1600 then divisor = 2 , if b1 > 1600 then divisor = 1.5 ,

Regards

Ingust

Glenno

12th November 2006 04:05 PM

Quote:

Originally Posted by ingust

The formula to use is =IF(B1<=1250,4,IF(B1<=1450,3,IF(B1<=1600,2,1.5)))

ingust

14th November 2006 05:49 AM

thank you Glenno for replying , but i still cant get it to work ,

here is what iam trying to do

distance factor =( 1.5 , 2 , 3 , 4 ) depending on the distance will =one of those 4 numbers

then that factor is divided into ( weight/limit ) / by one of the above factors

weight diff = ( wgt / limwgt ) / distance factor ,

regards

Ingust

ingust

17th November 2006 09:09 AM

thanks again Glenno
works ok now that i have copied in correctly ,

Regards
Ingust

All times are GMT +10. The time now is 08:55 PM.