View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yamxs850 Yamxs850 is offline
external usenet poster
 
Posts: 1
Default how to randomly alter thes figures?

I currently have to log my start/finish mileage for the 20 working days in each
4 week period.Nobody ever checks this but is required for tax purposes.Would it
be (easily) possible to get a spreadsheet to do this for me if I enter start at
begin of month and finish at end of month,and it would then fill in my
start/finish for each day,I would need to manually complete for the first time
as the day to day mileage can vary ,but thereafter (the following month) could
I get it to randomly alter the daily mileage to make it appear more
realistic say by a few % + o r- each day,so that its not identical each month.
How would I do this? if its possible.
thanks
remove niljunk to send e-mail.