=IF(E9<=E10,0,"else what")

Replace "else what" with what you want if condition isn't true.

"Rhonda" wrote:

I haven't used in forever and now need... I have cells formatted custome as
0;-0;;@ so that if there is a 0 it won't show and become visually in the way,
but now the other problem that I need is if the cell (e9) above my cell (e10)
is equal to or lesser than the formula should put a 0 in the cell and
therefore nothing will show.

should this be =IF(e10<=e9)THEN"0" or bracket use...really need the help.