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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|