I have a spreadsheet with a page called Calculator. In cell C16 there will be a number between 1 and 60 inclusive.
In another sheet in the same spreadsheet I want to check whether the number in cell C16 of Calculator is below 16 or over 46. If it is return Y, if it is not return N.
Having a problem with this
=IF(OR(C16<16;C16>46);"Y";"N")