Report

Range of numbers [Solved]

Ask a question whatsit - Last answered on Jan 21, 2017 at 07:42 AM by Mazzaropi
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 
Helpful
+0
moins plus
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
Leave a comment
Helpful
+0
moins plus
It works. Thank you Mazzaropi . I appreciate your help.
Leave a comment
Helpful
+0
moins plus
Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!