Ask Your Question
0

either or formula [solved]

asked 2019-03-03 21:53:51 +0200

briansmith gravatar image

updated 2019-03-05 14:14:02 +0200

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-03-03 22:12:35 +0200

=IF(OR(C16<16;C16>46);"Y";"N")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-03-03 21:53:51 +0200

Seen: 32 times

Last updated: Mar 05