Richard Buttrey

Posts: n/a

On Fri, 9 Sep 2005 07:25:01 -0700, "scott45"
wrote:

Thanks but it doesnt seem to work. I keep getting enter too many arguments.

Try

=IF(ISERROR(IF(X160,X16*F4)/SUM(F7:G7)),0,IF(X160,X16*F4)/SUM(F7:G7))

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

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
Can I prevent a #DIV/0! error from plotting on a chart	CTarantino	Charts and Charting in Excel	3	August 26th 05 08:35 AM
DIV/0! error in SumProduct formula with no division	Irrational	Excel Worksheet Functions	1	August 18th 05 01:39 AM
replace "#DIV/0!" error with blanks	Mark B	Excel Worksheet Functions	0	June 22nd 05 10:19 AM
# DIV/0! error in Excel	Helpwanted	Excel Discussion (Misc queries)	8	May 6th 05 09:31 PM
"Average" with error DIV/0	agenda9533	Excel Discussion (Misc queries)	1	March 2nd 05 05:47 PM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us