Posted to microsoft.public.excel.misc

Kmtravel

external usenet poster

Posts: 2

#VALUE! - Error

Perfect - thank you very much!!

"ck" wrote:

see if this works
=IF(ISERROR(C10/B10-1),0,C10/B10-1)

"Kmtravel" wrote:

I'm trying to get a percentage from the following formula c10/b10-1, the
problem i'm facing is that c/10 & b10 are zero value - I just want to make it
0%.

Any options? Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Excel 2007 - error saving file & error loading dll	TinaF	Excel Discussion (Misc queries)	0	July 1st 09 01:49 PM
Visual Basic Error Run Time Error, Type Mismatch	Meg Partridge	Excel Discussion (Misc queries)	12	September 10th 08 06:10 PM
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
Excel 2003 Macro Error - Runtime error 1004	Cow	Excel Discussion (Misc queries)	2	June 7th 05 01:40 PM

All times are GMT +1. The time now is 01:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us