A few questions (rank and charges)

**zwgator** · 10-07-2006, 09:49 AM

I need help with this. I need to find the best customer, by who has the most expensive order. (there are only five customers) and we have to rank it by the persons name.

Im not sure how to do this. I only know how to rank things by numbers say =rank(a3,a3:a7,1)

Question #2 how to I work with a number of different charges? say, for example, It cost $3 for each added letter and $5 for each added iron-on, in one cell, how would I calc. both of them? The # of letter and the # of iron ons have there own cell too. B cell is the letters, C cell is the iron ons and F cell is the total + the costs. I was thinking

=add(B3*3+C3*5) but i dotn know how to find the total

Question #3

How to add a discount. Say, If you got both a letter and an iron on (one of each or more) then you got 10% off your order. Do you use countif?

**Stuie** · 10-08-2006, 05:58 AM

did u want to write a button or just put formulas into a cell?? coz it wud be dead easy to make this all happen off a click of a button

**zwgator** · 10-08-2006, 10:58 AM

It doesn't matter, i dont think

**zwgator** · 10-08-2006, 11:03 AM

also, i get an #value error when I try this =SUM(B4*3+C3*5) where both B4 and C3 are equal to zero....i want it to equal 0 and not get an error

**starguy** · 10-09-2006, 05:54 AM

Originally Posted by zwgator

I need help with this. I need to find the best customer, by who has the most expensive order. (there are only five customers) and we have to rank it by the persons name.

Im not sure how to do this. I only know how to rank things by numbers say =rank(a3,a3:a7,1)

Question #2 how to I work with a number of different charges? say, for example, It cost $3 for each added letter and $5 for each added iron-on, in one cell, how would I calc. both of them? The # of letter and the # of iron ons have there own cell too. B cell is the letters, C cell is the iron ons and F cell is the total + the costs. I was thinking

=add(B3*3+C3*5) but i dotn know how to find the total

Question #3

How to add a discount. Say, If you got both a letter and an iron on (one of each or more) then you got 10% off your order. Do you use countif?

Ans#1

I suppose you have Customer names in col A and Order in col B and data starts from row1.

use following function to return Customer name which has highest order

=INDEX(A1:A5,MATCH(LARGE(B1:B5,1),B1:B5,0),0)

Ans#2

use simply
=B3*3+C3*5

Ans#3

if you have original price in col D and want to calculate discounted price in col E
use in col E
=D1-D1*0.1

Regards.

**zwgator** · 10-09-2006, 05:33 PM

Ok this is great! One more thing

I need to do a goal seek on this. I have a total, the amount of the discount (10%) and the total cost after the discount. Now, the discount for all five people is over $90 and I need to find the discount % rate if I wanted the total amount of the discounts to equal $40

How would I use goal seek to find this? Thanks

A few questions (rank and charges)

LinkBack

Thread Tools

Rate This Thread

Display

A few questions (rank and charges)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions