Excel for calculating charges min. max. cap

Something like

=MIN(50,MAX(5,B2*C2))

hi mate,

thank you for your reply.

i am a excel noob.

i need the whole code with the formula of the calculation.

please help me.

thank you

very much appreciated.

That is the "whole code".
Put your 10,000 or 300,000 in cell B2
Put the 0.03125% in cell C2
Put the formula I gave you in some other cell

hi mate,

it need the result to show

e.g. 46.87 when user type in 150,000 or 18.75 when user type in 60,000.

very close...

help thank you!

hi mate,
i got it

U R GOD!!!!!!

hi mate, thank you for the code.

now i have a minor problem. i have 5 colomns and rows for my codes.

the problem comes when i dont key in anything into the field and the default value 5 will be there and it affects my total fees calculation in the end.

i need something like, if value = not filled in by user, the charges dont show anything.

Please help me

thank you!

Put an IF() test around the formula:

=IF(C2="","",MIN(50,MAX(5,B2*C2)))

Thank u mate, I will try again tomorrow.

Thank u a million