“If” in a cell

[Eric Kelcher]

Trying to see if there is a way to essentially do an if in a cell so I can have updates in real time as opposed to running a Macro.
What I have is an ordering guide
Col A is description
Col B is minimum stock quantity (can be a fraction)
Col C is on hand quantity
Col D must be positive (there are times we will overstock an item) whole number rounded up of Col B- Col C

I can get everything working with simple equation and zero decimal places except for the negative numbers. ?

 

[Eric Kelcher]

I got it finally
Cell D1
=IF(C1=“”,””,IF(B1-C1<=0,””,IF(B1-C1<=0.5,1,B1-C1)))

 

[Fluff]

You can simplify that slightly like

=IF(OR(C1="",B1<C1),"",IF(B1-C1<=0.5,1,B1-C1))