|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 20th, 2009, 07:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Equation
I need an equation in a cell (P4) that will depend on:
1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of the amount, or 2) if the dollar amount in F17 is $200,000 to $250,000, the number in P4 is $1,700 and 3) if the dollar amount is over $250,000, the number is $2,200. Hope this makes sense -- MDL 
|
|
#2
May 20th, 2009, 07:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equation
=if(F17200000,.0075,if(f17250000,2200,1700))
"MDL" wrote: I need an equation in a cell (P4) that will depend on: 1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of the amount, or 2) if the dollar amount in F17 is $200,000 to $250,000, the number in P4 is $1,700 and 3) if the dollar amount is over $250,000, the number is $2,200. Hope this makes sense -- MDL
|
|
#3
May 20th, 2009, 09:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equation
I input the equation into the cell and $0.01 came up. The amount in F17 is
$135,040. Am I inputting sometning wrong? Thanks! -- MDL "Don" wrote: =if(F17200000,.0075,if(f17250000,2200,1700)) "MDL" wrote: I need an equation in a cell (P4) that will depend on: 1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of the amount, or 2) if the dollar amount in F17 is $200,000 to $250,000, the number in P4 is $1,700 and 3) if the dollar amount is over $250,000, the number is $2,200. Hope this makes sense -- MDL
|
|
#4
May 20th, 2009, 09:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equation
=if(F17200000,F17*0.0075,if(f17250000,2200,1700) )
-- David Biddulph MDL wrote: I input the equation into the cell and $0.01 came up. The amount in F17 is $135,040. Am I inputting sometning wrong? Thanks! =if(F17200000,.0075,if(f17250000,2200,1700)) "MDL" wrote: I need an equation in a cell (P4) that will depend on: 1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of the amount, or 2) if the dollar amount in F17 is $200,000 to $250,000, the number in P4 is $1,700 and 3) if the dollar amount is over $250,000, the number is $2,200. Hope this makes sense -- MDL
|
|
#5
May 20th, 2009, 10:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Equation
Perfect! Thanks so much.
-- MDL "David Biddulph" wrote: =if(F17200000,F17*0.0075,if(f17250000,2200,1700) ) -- David Biddulph MDL wrote: I input the equation into the cell and $0.01 came up. The amount in F17 is $135,040. Am I inputting sometning wrong? Thanks! =if(F17200000,.0075,if(f17250000,2200,1700)) "MDL" wrote: I need an equation in a cell (P4) that will depend on: 1) if the dollar amount is under $200,000 (in cell F17), the number I need in cell P4 will be .0075 of the amount, or 2) if the dollar amount in F17 is $200,000 to $250,000, the number in P4 is $1,700 and 3) if the dollar amount is over $250,000, the number is $2,200. Hope this makes sense -- MDL
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
