equaision displaying phantom numbers
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 |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com