No, I think you're right. It will only look at the first cell in the range.
Array entering gets rid of the #VALUE! error, but doesn't actually get it to
use the full array. It isn't clear, of course whether the OP wanted OR or
AND to apply to his range and his conditions.
--
David Biddulph
"Max" wrote in message
...
Perhaps you meant to do something like this
in say, IT27, copied down:
=IF(IS27=30%,"R",IF(IS27=20%,"A",IF(IS27=19%,"G ","")))
Test and modify to suit
I'm not sure that your expression is valid/works even with array-entering
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Excellwannabee" wrote:
Apologies:
=IF(IS27:IS3130%,"R",IF(IS27:IS3120%<29%,"A",
IF(IS27:IS3119%,"G","G")))
IS27:IS31 is the range where the data is in.