Thread: quick question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tmela tmela is offline
external usenet poster
 
Posts: 1
Default quick question


only a beginner any help would be appreciated.
Want to use the formula
=IF(C3=0,1,0) but if the cell C3 is blank (has no data) it is treating
it as 0.
any way around this problem?
Many thanks in anticipation of you help


--
tmela
------------------------------------------------------------------------
tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745
View this thread: http://www.excelforum.com/showthread...hreadid=573304