Calculation error in formula (Excel 2003 SP3)

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Calculation error in formula (Excel 2003 SP3)

Post by steveh »

Good afternoon

I am working on a tariff where the base rate includes 10 kilos and anything above that incurs a per kilo charge (The per kilo charge is based on a zonal tariff and changes according to the destination zone). I can get the formula to show the 10 kilos or less result but I cannot for the life of me get it to do the second part, the formula is

=IF(D22<=10,D23,IF(D22>10,D22-10*D24+D23)) :scratch:
You do not have the required permissions to view the files attached to this post.
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
Top
User avatar
rory
5StarLounger
Posts: 817
Joined: 24 Jan 2010, 15:56

Re: Calculation error in formula (Excel 2003 SP3)

Post by rory »

You are missing parentheses:
=IF(D22<=10,D23,IF(D22>10,(D22-10)*D24+D23))
Regards,
Rory
Top
steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Re: Calculation error in formula (Excel 2003 SP3)

Post by steveh »

Thanks Rory

You can't imagine how many variations of order, with brackets, without brackets I tried, I must have just missed this
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
Top

Return to “Excel and other spreadsheet applications”