I use it about once in 10 years, and always have a hard time figuring it out. I've got a cell in Excel that I want to show a number if another cell is greater than 0, or 0 if the other cell does not contain a numerical value. I've tried IF(B4>0,20,0) what's wrong? Thanks"!!