How do I write this formula in Excel?

W

woodie

Help, I need to write this as a formula in Excel
Below £30.multiply by 5.25% , Above £30,the first £30 multiply by
5.25%,then the remainder multiply by 3.25% ,Hope this makes sense,
Thanks Woodie
 
B

Bob Phillips

=MIN(A1,30)*5.25%+MAX(0,A1-30)*3.25%

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Help, I need to write this as a formula in Excel
Below £30.multiply by 5.25% , Above £30,the first £30 multiply by
5.25%,then the remainder multiply by 3.25% ,Hope this makes sense,
Thanks Woodie
 
M

macropod

hi Woodie,

For a value in A1:
=MIN(A1^1,30)*0.0525+(A1>30)*(A1-30)*0.0325
The ^1 suppresses an otherwise erroneous result if A1 is empty. You'll still
get an error if A1 has text, though.

Cheers

--
macropod
[MVP - Microsoft Word]


Help, I need to write this as a formula in Excel
Below £30.multiply by 5.25% , Above £30,the first £30 multiply by
5.25%,then the remainder multiply by 3.25% ,Hope this makes sense,
Thanks Woodie
 
D

Dana DeLouis

Just another option:

=MIN(A1*5.25%,A1*3.25%+0.6)

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


Help, I need to write this as a formula in Excel
Below £30.multiply by 5.25% , Above £30,the first £30 multiply by
5.25%,then the remainder multiply by 3.25% ,Hope this makes sense,
Thanks Woodie
 
Top