Posted to microsoft.public.excel.worksheet.functions

Ted[_2_]

external usenet poster

Posts: 3

getting #DIV/0! when calculating percentage

hi all, i'm not much of a guru with Excel. how do i prevent the #DIV/0! when
a column i'm dividing by is a 0.

i'm using Excel to calculate the Delta %. i'm using a simple formula
(K-L)/K. a lot of rows have values but obviously if for example K9 is 0 i'm
going to get an error. any ideas?

TIA
Ted

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
calculating a percentage	Jennnifer	Excel Discussion (Misc queries)	4	January 21st 08 11:04 PM
Calculating a Percentage	Reegan	Excel Worksheet Functions	2	November 9th 06 12:04 PM
Calculating a percentage with the end percentage in mind	Shadowshady	Excel Discussion (Misc queries)	2	June 17th 06 09:41 AM
Calculating Percentage	mconnolly	Excel Worksheet Functions	1	August 29th 05 09:48 PM
Calculating percentage	mac_see	Excel Worksheet Functions	1	March 12th 05 07:11 PM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us