View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Cells display nothing IF

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!


"Farhad" wrote:

Hi,

Try something like below:

=IF(your formula<0,"",yourformula)

Thanks,
--
Farhad Hodjat


"kim" wrote:

I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?