Range of numbers [Solved/Closed]

whatsit - Jan 19, 2017 at 11:39 PM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Jan 21, 2017 at 07:42 AM
hello, I would appreciate help on the following problem :-
If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is there a simple formula for this?
thank you in advance for your help.


See more 

3 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 20, 2017 at 12:12 PM
0
Thank you
whatsit, Good afternoon.

Try to use:

B1 --> =IF(AND(D1>=12, D1<=31), 2, "")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
Thank you
It works. Thank you Mazzaropi . I appreciate your help.
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 21, 2017 at 07:42 AM
0
Thank you
Thanks for the feedback.

Glad to be of help.
--
Belo Horizonte, Brasil.
Marcílio Lobão