LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I get rid of #DIV/0! part 2

Hi

I tried the suggestions that were given to me. The only problem is
that they will show a percentage in .00 instead of %. They want me to
get the the answer in %. I just cannot get this to work. It will
work once the cells are filled and it computes. But until then the
cell shows #DIV/0!


Original Message:

Hi,

How do I get rid of #DIV/0! in my cell when I used the following
formula?


=IF(Q3="","",1-(Q3/F3))


I have tried everything and it still shows up in my cells that use
this formula.


thanks for anyhelp that you can give me.

 
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
2 Part Formula ashley Excel Worksheet Functions 8 July 10th 07 09:27 PM
Replace Old Part Numbers with New Part Numbers in a Macro. Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM
Help on any part of this would be great Jimmycooker Excel Discussion (Misc queries) 0 February 7th 06 10:21 AM
Copying Part of a row down part of a column Not Excelling Excel Discussion (Misc queries) 3 January 6th 06 11:58 PM
Excel Web Part amy@harborcomputerservices Excel Discussion (Misc queries) 0 April 2nd 05 02:23 PM


All times are GMT +1. The time now is 12:40 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"