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

Try
=IF(C3="","",--(C3=0))

"tmela" wrote:


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

Try:

=IF(AND(C3=0,C3<""),1,0)

--
Damon Longworth

2006 West Coast Excel / Access User Conference
October 25-27th, 2006
Marina del Rey Hotel
Marina del Rey, California USA
http://www.exceluserconference.com/WCEUC.html

"tmela" wrote in
message ...

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