# excel HELP

[DELETED] 21:32 05 Dec 2003
Locked

hey there, i'm doing a computer selling company using excel using combo boxes and vlookup's and if's formula.IT's my college project...

anyway what i'm stuck on is.......i have a total for the pc in c25 without labour, i've put a labour charge column, but what i want to do is....
If a computer costs 455 in c25, then i want it to add the total in c25 PLUS 20% charged for the labour, and the new total into c26. ANY HELP WILL BE GRATeFUL

lindyloo4 22:01 05 Dec 2003

The formula you want in c26 is c25*(1+20%). That should work.

[DELETED] 22:18 05 Dec 2003

sorry that don't work, just comes up as £1.20, it don't change as c25 changes, anymore help?

[DELETED] 22:26 05 Dec 2003

In C26

=C25*1.2

If that and lindyloo4's suggestion do not work then, sorry, but you are not explaining the problem correctly.

[DELETED] 22:33 05 Dec 2003

right.....let me start again then. i have groups like \$400-£500,501-600, ect, at 400-500, i charge 20% of the total in c25 on top of the total for the parts. but at 501-600, i charge them at a different rate such as 18% for labour. so what i want to do is whatever number typed into c25, i have that figure and ADD the percentage on in c26, hope thats better. Labour Charge
1 £400-£599 20.00%
2 £600-£799 15.00%
3 £800-£999 12.00%
4 £1000-£1299 10.00%
5 £1300-£1599 8.00%
6 £1600-£1999 7.00%
7 £2000-£2499 6.00%
8 £2500+ 5.00%
theres my charge plans

lindyloo4 22:34 05 Dec 2003

Sorry, it comes up as 546 when I do it. You are typing c25* first before (1+20%). You need a excel expert and I'm afraid I'm not one.

Good Luck

[DELETED] 22:42 05 Dec 2003

=IF(A1>=2500,A1*1.05,IF(A1>2000,A1*1.06,IF(A1>1600,A1*1.07,IF(A1>1300,A1*1.08,IF(A1>1000,A1*1.1,IF(A1>800,A1*1.12,IF(A1>600,A1*1.15, A1*1.2)))))))

[DELETED] 22:51 05 Dec 2003

Copy and paste:

=IF(C25<=599,C25*0.2,IF(C25<=799,C25*0.18,IF(C25<=999,C25*0.12,IF(C25<=1299,C25*0.1,IF(C25<=1599,C25*0.08,IF(C25<=1999,C25*0.07,IF(C25<=2499,C25*0.06,IF(C25>=2500,C25*0.05,"ERROR"))))))))

This will work out your percentage from c25. Add the result to C25 to get your total charge.

Hope it helps.

[DELETED] 23:04 05 Dec 2003

Well, either silasgreenback's or mine would have worked - we approached it from different ends, as it were.

So nice of you to tell us that (which one?) worked.

[DELETED] 01:18 06 Dec 2003

both of them worked, thanks guys

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

How to watch the World Cup for free on TV and online

Meet Superfiction, the little design studio with a load of character

Best Mac music-production software

Comment savoir si votre message a été lu sur Facebook & WhatsApp ?