Nested IF function (urgent help needed)

**HJalal** · 02-28-2013, 11:45 AM

I am working on a formula where i need to meet 3 conditions.

1. If Miles[E13] is between 2.01 and 5 then (E13-H5)*K6
2. If Miles[E13] is less than 2.01[C6] then print Zero Value [0]
3. If Miles[E13] is great than 5[G6] then H6*K6

I created a formula but when I execute it, it gives an error of too many arguments.

Help will be highly appreciated.

See my sheet screen shot.

excel formula help.JPG

To finish off whole assignment, I also need help with multiple values,

Basically, it is a price calculation of a taxi. if the given miles are between the given range, then the price for first two miles will be @ £2.5 and next 3 miles will be @£2 and so on.

if the final price is less than minimum fare of £6 then the price should be £6.

Any help to complete this whole function with a single formula????????