OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Racing (http://forums.ozmium.com.au/forumdisplay.php?f=5)
-   -   Anyone know how (http://forums.ozmium.com.au/showthread.php?t=10314)

xptdriver 22nd July 2005 05:12 PM

Anyone know how
 
To convert a number in excel to another number... being specific I would like to do the following :

if h2 = 1 then I would like to convert that to 100
if h2 = 2 then I would like to convert that to 80
if h2 = 3 then I would like to convert that to 60
if h2 = 4 then I would like to convert that to 40
if h2 = 5 then I would like to convert that to 20
if h2 is greater than 5 I would like to convert that to 0

I am sure there is a way to do it but I am ************ed if I can...

iamcool 22nd July 2005 05:42 PM

1 Attachment(s)
XPT,

Had a play with excel for you - here is what you asked for.

Hope it is what you want.


xptdriver 22nd July 2005 07:35 PM

Gday iamcool

thanks alot for that.. that gave me what i wanted and also an idea of how to write my own IF formulae... thanks again

Wunfluova 22nd July 2005 09:34 PM

Another way to skin this cat would be :-

=IF(H2>5,0,120-H2*20)

Wun


All times are GMT +10. The time now is 11:40 AM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.