| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
I am looking to *A5 by 30% above $1 and lower the % by .1% for every $1 above
$1 total in D5. Like if it is $11 it would be 29% Thanks Roy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas
Hi Roy,
This formula returns 3.19 which is 11*29/100 =A5*((30-(A5-1)*0.1)/100) Is that what you are after? Ken Johnson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formulas
=A5*(30%-(D5-1)*0.1%)
-- HTH RP (remove nothere from the email address if mailing direct) "Roy E" wrote in message ... I am looking to *A5 by 30% above $1 and lower the % by .1% for every $1 above $1 total in D5. Like if it is $11 it would be 29% Thanks Roy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming | |||
![Roy E[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
