How do I write this formula in Excel?

[woodie]

Help, I need to write this as a formula in Excel
Below =A330.multiply by 5.25% , Above =A330,the first =A330 multiply by
5=2E25%,then the remainder multiply by 3.25% ,Hope this makes sense,
Thanks Woodie

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

"woodie" <3woodies@tiscali.co.uk> wrote in message
news:1150622653.267780.281160@u72g2000cwu.googlegroups.com...
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

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


"woodie" <3woodies@tiscali.co.uk> wrote in message
news:1150622653.267780.281160@u72g2000cwu.googlegroups.com...
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

[Dana DeLouis]

Just another option:

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

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


"woodie" <3woodies@tiscali.co.uk> wrote in message
news:1150622653.267780.281160@u72g2000cwu.googlegroups.com...
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