=IF(U24<0,"text1 text1",IF(AND(U240,U24<0.05),"text2
text2",IF(AND(U240.05,U24<0.1),"text3 text3",IF(AND(U240.1,U24<0.25),"text4
text4",IF(AND(U240.25,U24<0.5),"text5 text5",IF(AND(U240.5,U24<0.75),"text6
text6",IF(AND(U240.75,U24<1),"text 7 text7","text 8 text8")))))))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Morgan" wrote:

hi,

i've had a go at creating an IF funtion that will display one of a number of
phrases based on a particular value, however it comes up with some kind of
name error, what i'm after is i want it to display one piece of text if the
value is less than zero, another piece of text if the value is between zero
and 0.05 and so on, with the last IF function being if the value is less than
1 and greater than 0.75 display text7 and greater than 1 display text 8, does
somebody know how to fix it?

below is what i've got, i've swapped the actual text out for ease of use


=IF(U24<0,€�text1 text1€�,IF(U24<0.05,€�text2 text2€�,IF(U24<0.1,€�text3 text
3€�,IF(U24<0.25,€�text4 text4€�,IF(U24<0.5,€�text5 text5€�,IF(U24<0.75,"text6
text6",IF(U24<1,€�text 7 text7€�,€�text 8 text8€�)))))))
--
thanks