Calculation

S

Stewart

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

Pete_UK

I think this is what you mean:

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

assuming your percentage value is in A1.

Hope this helps.

Pete
 
Top