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 |
quick question
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 |
quick question
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 |
All times are GMT +1. The time now is 04:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com