we may filter it also,,by drilling down the default values for the hi and low
% limits as explained by Trevor..
something like for cost_% on column A
C1=if(A1< min_%,min_%,if(A1max_%,max_%,A1)
and same principle for profit_% on column B..
regards
--
*****
birds of the same feather flock together..



"Trevor Shuttleworth" wrote:

If you refer to your percentage calculation/formula as "ypc", the formula
might look like:

=IF(OR(ypc<low limit, ypchigh limit),default value,ypc)

Regards

Trevor


"TechyTemp" wrote in message
...
I'm working on two columns of percentages - cost and profit.
Occassionally,
the numbers are weird and so the percentages are either negative or
extremely
large. What kind of code can I write so that, if the numbers are not
within
a certain range,a default number is entered?