5punk

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?

Hehulk wrote:Is there some key flaw in my forumla?

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

Pff, thank you for the words of wisdom sir

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.