In article , Shane
Devenshire writes
I would get rid of the apostrophies, but if you must leave them then modify
the formula to read

=--IF(D2<=25,J2,IF(--J2=2,6,IF(OR(--J2=1,--J2=11),5,J2)))

or

=IF(D2<=25,VALUE(J2),IF(VALUE(J2)=2,6,IF(OR(VALUE (J2)=1,VALUE(J2)=11),5,
VALUE(J2))))

To remove the apostrophies from in from of a range of cells choose a blank
cell and click Copy. Then select all the text entires (the cells with
apostrophies) and choose Edit, Paste Special, Add.


Hi Shane and Lars-Ake

OK thanks for that - its working perfectly now.

After some trial and error , I actually got around it in a more
long-winded way , by multiplying by 1 and copying down. I can see that
your solution is neater , but got there in the end.

Thanks for your time and expertise , I'm grateful.


Best Wishes