Excel Formula...

[asonda]

Hi All,

I'm having trouble with a Formula in Excel.

I have different pricing bands that I want the formula to look at, then include a set figure, then check again for additional amounts and add.

E.G

If I want to work out how much to charge a customer for 46.

I need the formula to be able to say, ok this fits BAND D at 40 and then needs to add the cost of the additional 6.

Example

Example Amounts:
Band A was 10 at £10..........Extra A £1
Band B was 20 at £20..........Extra B 90p
Band C was 30 at £30..........Extra C 80p
Band D was 40 at £40..........Extra D 70p

so for 46.

It would need to see that it is BAND D, plus add that to 70px6 which would give:£44.20

Of course dependant on the original number, it would need to both identify which band to charge and then which Extra Band to multiply by anything over that band.

I'm tearing my hair out here.

Cheers

Jamie

 

[PuddlePayroll]

Can I send you something? Would be much easier than typing it out here!

 

[asonda]

Yeah Sure I'll PM you my E-Mail Address.

Thanks!

 

[asonda]

Just want to say a big thanks to PuddlePayroll.

He's made a sterling effort to help me out in my hour of need and has come through.

Top respect for this gentleman

 

[PuddlePayroll]

Very kind of you. It was no problem at all.

 

[35173]

This article might be useful:

http://www.ittrainingsolutions.co.uk/rp-excel-sumif-function-help-what-is/

Or this one perhaps:

http://www.ittrainingsolutions.co.uk/rp-excel-complex-if-functions-help-tips/

Otherwise I'm not sure how to help.

Hope one of those articles proves helpful.