Greater Than 0 & Less Than 30

Solved/Closed
Game Start Now - Jan 22, 2010 at 10:25 AM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Jan 29, 2010 at 07:50 AM
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
Related:

3 replies

Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Jan 27, 2010 at 12:08 AM
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
0
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
0
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Jan 29, 2010 at 07:50 AM
Thx Dude

Well I Have A New Question

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

Here is your formula:

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

Best regards,
Trowa
-1
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Jan 26, 2010 at 11:52 PM
your given formula is not working my friend.......

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

Thanks & Regards
Naeem
0