Range of numbers [Solved/Closed]

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
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.


4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
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
It works. Thank you Mazzaropi . I appreciate your help.
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Thanks for the feedback.

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