Posted to microsoft.public.excel.misc

tom

Posts: n/a

advanced IF statment

Hello,

i was wondering if anyone could tell me how to create an IF statement where
i want to compare a a set criteria to a result and give it 1 mark it it makes
the criteria and then and extra 1 point for ever 5% it is above the criteria

thankyou

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
Advanced Filters	Louise	Excel Worksheet Functions	3	September 26th 05 11:57 AM
advanced filter criteria "begins with" and "does not begin with"	raph_baril	Excel Worksheet Functions	3	June 28th 05 10:38 PM
Using advanced filter to search for criteria in a list	Potatosalad2	Excel Discussion (Misc queries)	1	June 8th 05 03:08 AM
Advanced Find Command??	Debbie	Excel Discussion (Misc queries)	1	February 4th 05 09:07 PM
Can Excel advanced filter be used in "and NOT" mode	Robert	Excel Worksheet Functions	1	January 27th 05 02:57 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us