Gord Dibben
12/15/2006 6:33:00 PM
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 <walt@discussions.microsoft.com> 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