Thread: if cell value is 0 than another cell value should be zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default if cell value is 0 than another cell value should be zero
=if(isblank([datecolumn]),[actual expenses],0)
--
Brevity is the soul of wit.


"EXCEL USER" wrote:

I am trying to enter formula in which one column is with project closing
date and if there is a date entered in such cell tha I like to calculate the
value to zero and if such cell is blank than i like to enter actual expenses
from actual expense cell please help how and what formula should i use? you
can reply me at , Thanks,
Reply With QuoteReply With Quote