Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can a cell be formulated to reflect a value based on the following situation?
Cell C5 is $34000.00; the first $1600.00 of that amount + the value of C7 needs to be multiplied * 2.25%. That value will be in cell C10. ALSO, Cell C5 is $34000.00; the second $1600.00 up to $3200.00 needs to be multiplied * 2.75%. That value will be in cell C11. EXAMPLE: $34000.00 1st level 1600.00 * 2.25% = $36.00 2nd level 1600.00 * 2.75% = $44.00 ANOTHER EXAMPLE: $3000.00 1st level 1600.00 * 2.25% = $36.00 2nd level 1400.00 * 2.75% = $38.50 I am using Excel 2003 version. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulation question | Charts and Charting in Excel | |||
If formulation: Is it possible... | Excel Discussion (Misc queries) | |||
If formulation | Excel Discussion (Misc queries) | |||
Time formulation? | Excel Discussion (Misc queries) | |||
cell in cell formulation possible??? | Excel Discussion (Misc queries) |