IF(B440<0,0,(B440))
Above is my formula to show only positive numbers above 40 in the given cell. If my hours are ...lets say 35, I do not want a value of 5, I want the cell value to be 0. Why is this not working?
Above is my formula to show only positive numbers above 40 in the given cell. If my hours are ...lets say 35, I do not want a value of 5, I want the cell value to be 0. Why is this not working? 

closed as not a real question by Breakthrough, Simon Sheehan, 8088, Ƭᴇcʜιᴇ007, terdon Dec 11 '12 at 3:10It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question. 


I see no reason for that formula to work. Ensure the value stored in B4 is an integer and not a string. It's possible the order of operations is being misinterpreted: as written,
I've verified that both the above formula, as well as the original, do indeed work properly on both MS Excel 2007 under Windows, as well as Gnumeric under Linux. 


You are missing an



Your original formula as you have shown it is missing the "=" (equals) sign at the beginning of the formula. Without the "=" sign, the formula will be shown as text. I also don't see a reason why that formula isn't working for you, assuming you do have the "=" sign at the beginning of the formula. I would have written it a little differently:
You can test if B4 is actually a number (rather than a string) like this:
Please note that if you are using OpenOffice Calc rather than Microsoft Excel, you will need to use semicolons (;) instead of commas (,) like this:



It works for me, I get 0 for values less than 35 or 35, what version of excel you are using? You can also check type of each of your cell that could cause potential issues. 

