OZmium Sports Betting and Horse Racing Forums

		OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
Excel Help

	To advertise on these forums, e-mail us.

Page 2 of 2

#11

27th August 2006, 08:43 PM

OZDOC

Member

Join Date: Jan 1970

Posts: 40

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

Page 2 of 2

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

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