Complicated Maths Calculation

[jasoneon9]

Hi 

 

I am trying to figure out a complicated maths field for my dads storage yard the prices are based on a percentage sliding scale on an excel worksheet, as he has many size's of containers

 

He has a base price of £10 never changes then its 1% per day based on the storage price there's about 50 different prices that change from month to month 

 

 

field 1, Storage_Price

 

field 2, Days

 

field 3, Storage_Fees

 

so it should be Storage_Price "£10" x Days "28" = Storage_Fees "£2.80"

 

field 4, Base_Fee

 

field 5, Total_Due

 

 + Base_Fee "£10" = Total_Due "£22.80"

 

i hope that's clear as im kinda confused just reading it back myself

 

so the storage fee is £10 x 28 days each day is 1% 10p a day x 28 days = £2.80

add the base fee also comes to £22.80

 

it works ok from his spread sheet but then we have to enter all data by hand just all to slow

 

so just need to know how to write the Storage_Fees calculation

 

many thanx in advance 

[eos]

If I read your description correctly, that would be

 

Total_due =

Let ( [
  sp = Storage_Price ;
  percentage = 1 ;
  sf = sp / 100 * percentage * Storage_days
  ] ;
  sp + sf + Base_Fee
) 

[jasoneon9]

Dammmm eos  youre good that worked 1st time   thank-you very much that has save me hours i reckon