| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formmula to gives a % split for dif. $ amounts
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a formmula to gives a % split for dif. $ amounts
Bit sparse on detail.
A guess =A1/A2 and format as percentage. -- HTH RP (remove nothere from the email address if mailing direct) "Duck" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a formmula to gives a % split for dif. $ amounts
Im tying to put the retail price in E3 and calculate the % in F3 and G3
$0 to $2000 53% 47% split $2001 to $8000 57% 43% split $8000 up 61% 39% split So it will recognize each price break. Can this be done? This only will come up with the first percentage break. =IF(E30,47%*E3,IF(E3<=2001,43%*E3<=$8001,39%*E3)) "Bob Phillips" wrote: Bit sparse on detail. A guess =A1/A2 and format as percentage. -- HTH RP (remove nothere from the email address if mailing direct) "Duck" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a formmula to gives a % split for dif. $ amounts
F3: =E3*VLOOKUP(E3,{0,0.53;2001,0.57;8001,0.61},2)
G3: = E3-F3 -- HTH RP (remove nothere from the email address if mailing direct) "Duck" wrote in message ... I'm tying to put the retail price in E3 and calculate the % in F3 and G3 $0 to $2000 53% 47% split $2001 to $8000 57% 43% split $8000 up 61% 39% split So it will recognize each price break. Can this be done? This only will come up with the first percentage break. =IF(E30,47%*E3,IF(E3<=2001,43%*E3<=$8001,39%*E3)) "Bob Phillips" wrote: Bit sparse on detail. A guess =A1/A2 and format as percentage. -- HTH RP (remove nothere from the email address if mailing direct) "Duck" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO MATCH AND ELIMINATE AMOUNTS IN TWO COLUMNS IN EXCEL | Excel Worksheet Functions | |||
| Killing the split window | Setting up and Configuration of Excel | |||
| Enable a new dimention: sub-level of split cells | Excel Discussion (Misc queries) | |||
| How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
| sumproduct to add total amounts for the month | Excel Worksheet Functions | |||
Linear Mode
