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

=if(F17<200000,.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

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(F17<200000,.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

=if(F17<200000,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(F17<200000,.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

Perfect! Thanks so much.
--
MDL


"David Biddulph" wrote:

=if(F17<200000,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(F17<200000,.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