M
Morgan
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â€)))))))
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â€)))))))