Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default Hidding #DIV/0! In Cell

Xena_Peel wrote...
I am working on a form where I am putting formulas in order for
other users of the the form can plug in numbers and they can get a
sum. The formula is =(c19/c18) and until numbers are placed in the
cells mentioned, there will be "#DIV/0!". How would I hide this
without hiding the sum for the formula when numbers are entered into
those cells.


First off, your formula is a ratio, not a sum.

Next, #DIV/0! errors caused by blank cells are better handled in the
formula than by formatting. Change your formula to

=IF(N(C18),C19/C18,"")

Reply
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
Hidding #DIV/0! In Cell Xena_Peel Excel Worksheet Functions 3 May 23rd 07 06:53 PM
Hidding formulars used in a worksheet Worksheet Formulars Excel Worksheet Functions 1 April 27th 07 09:26 AM
Hidding the formula and limiting users bimseun Excel Discussion (Misc queries) 1 April 4th 06 10:45 AM
Hidding Macro names and coding mrbalaje Excel Discussion (Misc queries) 4 April 20th 05 04:23 PM
Hidding Tabs Aviator Excel Discussion (Misc queries) 1 December 15th 04 04:55 PM


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