Range of numbers

Solved/Closed
whatsit - Jan 19, 2017 at 11:39 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.


Related:

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 20, 2017 at 12:12 PM
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
It works. Thank you Mazzaropi . I appreciate your help.
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 21, 2017 at 07:42 AM
Thanks for the feedback.

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