Failing with formula
Hey Charlie
You could do something like this:
=IF(AND(B81,B8<5001),1,IF(AND(B85000,B8<10001),2 ,"Outside Range"))
This has one IF statement nested within another to handle your two listed
requirements, and if over 10000 then will display text 'Outside Range'. Nest
further IF statements if you need to.
Regards,
Lee
You are limited to 7 nested IF statements, not sure if this is still the
case in the latest Excel version, so if you need to go beyond 7 levels of
checking then another approach is probably needed.
"Charlie" wrote:
Hi,
I need to create a formula the will give the following results:
IF B8 is between 1 and 5000 the result is 1, if B8 is between 5001 and 10000
the result is 2 and so on.
Any help would be appreciated.
Many thanks
Charlie
|