View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jermsalerms
 
Posts: n/a
Default Problem removing 0


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