Hi Kevan,

Well that makes a lot more sense to me,

Good luck.
Shane

"kevan" wrote in message
...
Thanks Shane it worked perfectly once I had corrected my own error about
cell
numbers....

=IF($AG2="3-6",6,IF($AG2="7-10",10,IF($AG2="11-14",14,IF($AG2="18-21",21,IF($AG2="22-25",25,
"Not OK")))))

Thanks again
--
kevan


"ShaneDevenshire" wrote:

Hi,

There may be a logic error here, if AG2 does not contain 3-6 the formula
returns "Not OK". Once that is done the function would not go on to check
AG3. If it did it would return something like Not OK, Not OK, Not OK,
21,
Not OK. Would you really want all those answers. Here is probably what
you
want:

=IF($AG$2="3-6",6,IF($AG$3="7-10",10,IF($AG$4="11-14",14,IF($AG$5="18-21",21,IF($AG$6="22-25",25,
"Not OK")))))

You don't need to quote numbers so I took those quotes out.
--
Thanks,
Shane Devenshire


"kevan" wrote:

I am trying to combine the following if functions with an or funtion
which
will provide mw with the answer 6,10,14,21 or 25.
=IF($AG$2="3-6","6", "Not OK")
=IF($AG$3="7-10","10", "Not OK")
=IF($AG$4="11-14","14", "Not OK")
=IF($AG$5="18-21","21", "Not OK")
=IF($AG$6="22-25","25", "Not OK")

My attempts so far are futile. Can anyone help?

Thanks


--
kevan