Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

Syntax errot

Please advise how to correct syntax error in the following:

if min(a5:a9)< avg(a5:a9)*0.95 and if max(a5:a9) avg(a5:a9)* 1.05
then a13 = "fail" else a13 = "pass"

Thank you

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
Syntax	[email protected]	Excel Programming	2	June 22nd 07 04:13 PM
Run Time errot 1004, with formula	mikeb	Excel Programming	3	November 7th 06 06:45 AM
If then syntax	RL	Excel Worksheet Functions	3	June 22nd 05 05:30 AM
SQL syntax	Jeffiec	Excel Programming	1	June 14th 05 05:47 PM
errot in macro	Sanford Lefkowitz	Excel Discussion (Misc queries)	1	January 3rd 05 11:27 PM

All times are GMT +1. The time now is 08:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us