LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Problem With Reference Update Egon Excel Worksheet Functions 17 July 16th 05 05:45 AM
Removing grids Zapiszsie Excel Discussion (Misc queries) 2 July 5th 05 08:54 AM
Copy an Drag cell Formula Problem Nat Excel Discussion (Misc queries) 1 June 20th 05 03:24 PM
problem office assistant R.VENKATARAMAN Excel Discussion (Misc queries) 0 June 15th 05 06:22 AM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"