Previous Topic Next Topic

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 responses

Answer 1 / 3
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
Answer 2 / 3
Trowa
Jan 29, 2010 at 07:47 AM
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
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..........
Answer 3 / 3
Trowa
Jan 26, 2010 at 08:58 AM
Hi Naeem,

Here is your formula:

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

Best regards,
Trowa
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

Similar discussions

,">"&0),"") at the end of a countif formula
jutulu -
toony -

4 responses
554: 30 Sorry, your message cannot be delivered
JB -
HelpiOS -

1 response
This mailbox is disabled (554.30)
soimi -
Soimi -

6 responses
Diskette Drive 0 seek failure (error message)
azajewel -
TechIlliterate -

133 responses