OZmium Sports Betting and Horse Racing Forums - Newletter Spreadsheet Solution

		OZmium Sports Betting and Horse Racing Forums > Public Forums > Sports and Gambling
Newletter Spreadsheet Solution

	To advertise on these forums, e-mail us.

28th June 2006, 08:27 PM

jfc

Member

Join Date: Jan 1970

Location: Sydney

Posts: 402

Newletter Spreadsheet Solution

A = Amount
B = Start Date
C = End Date

To produce Liability in Column D

=if ( today() < c1, a1*( c1 - today()) / (c1-b1), 0)

1st July 2006, 01:07 PM

Management Management is offline

Administrator

Join Date: Nov 1999

Posts: 1,764

Thanks, JFC.

That's brilliant, exactly what we need. I might have to give you a call to help apply the equation but it looks simple.

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 02:48 AM.