formula needed

[tmallow]

Im trying to find a formula that will calculate my fees.... D4 is the number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more = $1.31 plus 2.75%
anyone have any ideas on this one?

 

[Bob Phillips]

Try,

=IF(D4<=25,D4*5.25%,1.31+(D4*2.75%))

If it's currency, you might want to round it to 2 dec pl.

=ROUND(IF(D4<=25,D4*5.25%,1.31+(D4*2.75%)),2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Im trying to find a formula that will calculate my fees.... D4 is the

number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more =
$1.31 plus 2.75%

 

[Ken Wright]

=IF(D4<=25,D4*0.0525,D4*0.0275+1.31)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Im trying to find a formula that will calculate my fees.... D4 is the number

im using.... if it is $25 or less = 5.25%, if it is $25.01 or more = $1.31 plus
2.75%

 

[Michael]

Try

=IF(C7<25.01,C7*0.0525,IF(C7>25,1.31+(C7*0.0275),""))
Regards
Michael

-----Original Message-----
Im trying to find a formula that will calculate my

fees.... D4 is the number im using.... if it is $25 or
less = 5.25%, if it is $25.01 or more = $1.31 plus 2.75%

 

[Ken Wright]

He's not going to want to sell exactly $25 worth if that is what he gets

Need to trap the =25 which also makes the second IF superfluous. OP only really
has two scenarios of <=25 and >25 meaning they can both be catered for with a
single IF statement using the If True and If False arguments. It's either <=25
or it's not, or conversely it's either >25 or it's not. Either way it's a TRUE
or FALSE scenario.

 

[tmallow]

it seems i left a part of the factor out gentlemen...thank you so far....a little added twist.....of the amount over $25 the remainder is what the 2.75% is applied t
any ideas on the formula for that

----- tmallow wrote: ----

Im trying to find a formula that will calculate my fees.... D4 is the number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more = $1.31 plus 2.75%
anyone have any ideas on this one?

 

[Bob Phillips]

=IF(D4<=25,D4*5.25%,1.31+(D4-25)*2.75%)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

it seems i left a part of the factor out gentlemen...thank you so far....a

little added twist.....of the amount over $25 the remainder is what the
2.75% is applied to

any ideas on the formula for that?

----- tmallow wrote: -----

Im trying to find a formula that will calculate my fees.... D4 is the

number im using.... if it is $25 or less = 5.25%, if it is $25.01 or more =
$1.31 plus 2.75%