Excel - Formula - Greater than 0 or less than 30

Excel - Formula - Greater than 0 or less than 30
March 2015

[Excel] Formula - Greater than 0 or less than 30

Issue
Solution
Note that
See also: Excel greater than but less than

Issue

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".
Solution

Here is your formula:

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

Note that

Thanks to Trowa for this tip on the forum.
For unlimited offline reading, you can download this article for free in PDF format:

Excel-formula-greater-than-0-or-less-than-30.pdf
See also

Excel greater than but less than
If function excel greater than and less than
More or less zero sign in excel
If date in cell is greater tha