OZmium Sports Betting and Horse Racing Forums

Page 2 of 2

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

- General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)

- - Excel Help (http://forums.ozmium.com.au/showthread.php?t=14352)

OZDOC

27th August 2006 09:43 PM

Quote:

Originally Posted by Crackone

the result is eg $4 in A1 =$1.75 if you put $5 in result is $2

Why dont you just format your cells to currency?
then you only need
=(A1-1)/4+1

All times are GMT +10. The time now is 12:02 PM.

Page 2 of 2