I think this is what you mean:

=IF(A10.04,A1/0.04,A1/0.5)

assuming your percentage value is in A1.

Hope this helps.

Pete

On Mar 16, 9:57 pm, Stewart wrote:
I have a calculation that gives me a percentage. This percentage needs to
then be divided by .50. However, if the percentage in the field is greater
than 4% it only divides it by 4%, no more. How would this be written?