Greater Than 0 & Less Than 30

[Solved/Closed]
Report
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
Hello,

i need the formula of this quotation:

B2 Is Input Value Cell
D2 Is Formula Cell

If Cell B2 Is Greater Than 0 & Less Than 31, Than Formula Cell Shows "Yes" Else Shows "No"

Waiting For Your Reply Friends.

Regards,

Naeem Baig

3 replies

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Thx Dude

This Formula Is Working.................

I Just Change The ";" into Coma "," & Than It Works :)


=IF(B2>=0,IF(B2<31,"Yes","No"),"No")

Thanks & Regards,

Naeem
Indeed, I forgot to change the ";" into a ",".
It's the difference between european and american version of excel.
I'm glad to see you figured it out.

Best regards,
Trowa
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Thx Dude

Well I Have A New Question

Please Check It Out..........
Hi Naeem,

Here is your formula:

=IF(B2>0;IF(B2<31;"Yes";"No");"No")

Best regards,
Trowa
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
your given formula is not working my friend.......

please check your self first & than tell me.........

Thanks & Regards
Naeem