Excel formula help please

[Joella]

Are there any excel experts around? I want to write a formula that will change the value of a cell to n if it is between two numbers. For example if the value of the cell is greater than 6 and less than 18 the cell becomes n

I'm not even sure if this is possible to do and I'm a bit of an excel novice

Thank you for any help

[shg]

Welcome to the forum, Joella.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.