Formula for Minimum and Maximum amounts

Hello.

Apologies if this is not the right area as I am new to this forum milarky!!

I have to produce an excel spreadsheet and one part on it need the following:

All staff receive a higher cost allowance which is 20% of their salary. This bit I can do, but there is a minimum and maximum amount that they can receive.

Can this be done using one formula so that the cell reflects either the minimum, maximam or the actual figure between this.

Sorry if this is a really simple thing to do and I have just made myself sound really dumb

Thanks
Karen

Try

=MIN(MAX(A2*B2,D2),E2)

A2 = Salary
B2 = 20%
D2 = Minimum Amount
E2 = Maximum Amount

Thanks all. Wow. That was really quick with the replies. Glad that I did not sound stupid ... or you are letting me believe that I do not!!

Thanks again

Glad to help, thanks for the feedback.

Wise man say "The only stupid question is the one you do not ask"