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?

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?

=IF(A1<=0.04,A1/0.5,A1/0.04)


"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?

If C1 is the cell with the calculation,
then place in D1:
=IF(C14%,C1/4%,C1/50%)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?