Why doesn't it work. Why....

[Hehulk]

I'm trying to re-write one of my spreadsheets so that if the data in a cell is less than 0, it only displays 0. Tried a couple of IF forumlas, and according to what I can dig up from google they should work, but I'm getting #NAME? Errors instead. The forumla in question goes at thus:

=IF(B15-B14<0,0,B15-B14)

the data in B15 is my stock amounts, and B14 is what I need. Is there some key flaw in my forumla?

[TezzRexx]

Is there some key flaw in my forumla?

Yeah, it's wrong. As it's not working. DUH.

[Hehulk]

Pff, thank you for the words of wisdom sir

[friznit]

Code: Select all

=IF((Usage!F10-L6)<0, 0,(Usage!F10-L6))

Works for me. You'll also notice if you look carefully that this is your spreadsheet Once I've tidied it up a bit I'll email you a copy.