Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to figure out the percentage of units sold. I have 4 possible
products to sell each customer. I already have it so if i enter an amount greater than 1 under one of the products, i get a 1 in a cell and if i dont enter an amount i get a zero using the formula "=IF($G21,"1","0")". I would like to have it calculate the percentage based on each customer. For example, if in row 2(customer1) i sell a product, it should display 100%. Then in row 3 (customer 2) i do not sell a product, it should display 50% without changing the 100% in row 2. I hope this makes as much sense to you as it does to me. I can give a more detailed explanation for anyone who is willing to help. |
#2
![]() |
|||
|
|||
![]()
Hello fniguy-
Am not sure of your request but haven't had time to look at it thoroughly, but one thing I did notice... If the actual formula in your worksheet has quotes around the 1 & 0 as shown in your post, they need to be _removed_. The results they give if the quotes are used are the Text characters 1 & 0, not the Numbers 1 & 0. Text characters present a challenge if you want to use them for calculations. HTH |:) "fniguy24095" wrote: I would like to figure out the percentage of units sold. I have 4 possible products to sell each customer. I already have it so if i enter an amount greater than 1 under one of the products, i get a 1 in a cell and if i dont enter an amount i get a zero using the formula "=IF($G21,"1","0")". I would like to have it calculate the percentage based on each customer. For example, if in row 2(customer1) i sell a product, it should display 100%. Then in row 3 (customer 2) i do not sell a product, it should display 50% without changing the 100% in row 2. I hope this makes as much sense to you as it does to me. I can give a more detailed explanation for anyone who is willing to help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculate monthly average percentage of change | Excel Worksheet Functions | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
calculate percentage | Excel Worksheet Functions | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions | |||
calculate percentage of two cells | Excel Worksheet Functions |