Excel formatting question

Jenbug, on Wednesday June 11, 2008 04:03:36 AM

Hello,
I am trying to figure our how to get the cell to return either a "0" or a blank look when there are no values using the formula in place. This is only happening when I am dividing to cells values to get a new value in that cell. When there is nothing being divided it shows #DIV/0! ....thus I would like to see something other than this while it hasn't been used. can you please help!!!

Configuration: Windows XP
Internet Explorer 7.0

Reply to Jenbug Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

aquarelle, on Wednesday June 11, 2008 07:45:49 AM

Hi,
Maybe you can write something like that :

=IF(ISERROR(C2/C3);"";C2/C3)

Best regards

"Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

Reply to aquarelle

Ask your question Reply

Results for excel formatting question

DATE FORMATTING IN dd/mm/yyyy Hello, i have got dates typed in the format following 01.08.98 and i want to change it to 01/08/1998 format.i tried applying the format we have in excel format cell date format but nothing is happening.please help me on this. en.kioskea.net/forum/affich-22133-date-formatting-in-dd-mm-yyyy

Excel format Hello, I have a spreadsheet with a column which is supposed to represent dates. However cells are of the format of 25 12 08 - this example represents 25 December 2008 in European format. However the data sorts as numbers rather than a date. I want to... en.kioskea.net/forum/affich-44229-excel-format

Excel Date Format (Solved) Hello, when users enter a date in excel using this format 12.1.2008, i need the cell to automatically change the format to 12-Jan-08 thanks, moses en.kioskea.net/forum/affich-19164-excel-date-format

More answers

Results for excel formatting question

How to convert Excel into PDF?How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. PDF995 is software that gets installed on your computer which enables you to print any sources of document to PDF.... en.kioskea.net/faq/sujet-552-how-to-convert-excel-into-pdf

How to insert picture background on Microsoft!How to insert picture background on Microsoft! To make a work sheet more appealing, you can add picture to your background. Below is a tip for doing so. Open your Microsoft and select “Format”> “Backgrounds” > “Printed... en.kioskea.net/faq/sujet-334-how-to-insert-picture-background-on-microsoft

[Excel] Adding a fixed date in a cell[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the... en.kioskea.net/faq/sujet-1142-excel-adding-a-fixed-date-in-a-cell

More answers

Results for excel formatting question

Date format in excel.Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead. Then when I save any changes... en.kioskea.net/forum/affich-16756-date-format-in-excel

Changin format of date in excelHello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/mm/yy. How can I do that, pls help. eg - I need to convert "sat Jun 29 00:00:00 PST 1996" to "29/06/96".... en.kioskea.net/forum/affich-28689-changin-format-of-date-in-excel

Custom date formatHello, i need to change the format of dates in excel to read as 1st September 2008 2nd September 2008 and so on en.kioskea.net/forum/affich-26734-custom-date-format

More answers

Results for excel formatting question

Download MP3-CheckFormat MP3 is audio format par excellence for audio compression. But it is really possible that there are errors in formats, notably graffiti there. MP3-Check is an application which allows to prove your music collection for quality and possible... en.kioskea.net/telecharger/telecharger-696-mp3-check

Download LiveProject Free Project ViewerLiveProject is an application of visualization of file mpp free. LiveProject introduces no degradation of the file mpp during exportation in format Excel or html. With LiveProject, you will be able to print your own documents. The use of LiveProject... en.kioskea.net/telecharger/telecharger-860-liveproject-free-project-viewer

Download Free PowerPoint/PPT to Pdf ConverterIt is frequent to convert Word, Excel or image files to PDF format. But it is not very common to convert a PowerPoint file to the PDF format. PowerPoint / PPT to Pdf Converter is an application allowing to convert easily and quickly PowerPoint... en.kioskea.net/telecharger/telecharger-1445-free-powerpoint-ppt-to-pdf-converter

More answers

Results for excel formatting question

Formatting a hard disk Before trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even... en.kioskea.net/repar/format.php3

Video and digital imaging - The GIF format The GIF format (Graphic Interchange Format) is a bitmap (raster) graphic file format developed by Compuserve. There are two versions of this file format developed respectively in 1987 and 1989: GIF 87a supporting LZW compression, interlacing... en.kioskea.net/video/format-gif.php3

Spreadsheets - The Excel Interface Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel document is called a file... en.kioskea.net/tableur/tabinterface.php3

More answers