Hi,

There may be a problem with the problem as stated - 30% and 20% don't fit
into any category? On the other hand lets suppose your want somethning like
this: (array entered)

=IF(Range30%,"R",IF(Range20%,"A","G"))

However, it might be helpful to see a sample of the data because it is not
really clear what you are doing. Include the COUNTIF function you are
using.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Excellwannabee" wrote in message
...
Background:
Our projects are divided into Categories on a spreadsheet and we have a
criteria for the overall Red, Amber, Green Status that we give for each
category.
I have managed to use the Countif formula to count the Red, Amber and
Green
status for each catergory. I used a nested If statment but it keep
returning
a #Value!

The criteria is % of Amber and/or Red is more than 30% of overall for that
category then it is Red.
If % of Amber and/or Red is more than 20% but less than 29% then overall
status for the category should be Amber.
If % of Amber and/or Red is less than 19% then overall status for the
category should be Green.
Please can someone tell me how I can use the above criteria on a range of
cells with percentages to be able to give me the Red, Amber or Green
Status
for a category?