Range of numbers

Solved/Closed
whatsit - 19 Jan 2017 à 23:39
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 21 Jan 2017 à 07:42
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 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
20 Jan 2017 à 12:12
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.
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
21 Jan 2017 à 07:42
Thanks for the feedback.

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