Helper Sheet AQ2:AQ901 contain phone numbers
some have been entered 0 when there is no number provided. I am trying
to write a formula that will state if AQ2 = 0 then field is blank.
in cell V2 I have tried to write all the following formulas and all
result with the 0 still remaining
=IF(ISNUMBER('Helper Sheet'!AQ2)="0","",IF('Helper
Sheet'!AQ2="","",'Helper Sheet'!AQ2))
=IF(ISTEXT('Helper Sheet'!AQ2)="0","",IF('Helper
Sheet'!AQ2="","",'Helper Sheet'!AQ2))
=IF('Helper Sheet'!AQ2="0","",IF('Helper Sheet'!AQ2="","",'Helper
Sheet'!AQ2))
any other suggestions
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=501136