You don't want to force it to zero, you want to have it show blank.

=IF(C13="","",((C13-25000)/1000)*5+174)


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 09:05:01 -0800, walt wrote:

I have the following equaision that works great but displays a "phantom "
number even if the c13 is blank or 0.
anyway to force it to 0 untill a number is entered

=((C13-25000)/1000)*5+174