6 conditions formula

		Microsoft Office Forums > Microsoft Excel > Excel
6 conditions formula

FAQ

Thread Tools

Display Modes

03-02-2012, 05:05 PM

JBeaucaire JBeaucaire is offline

Windows XP 6 conditions formula

Office 2003

Advanced Beginner

Join Date: Dec 2011

Posts: 51

Code:

And I have the following information:

Score   Target  Month 1  Month 2  Month 3  Month 4  Month 5  Month 6
  2       90     100      100      100      100      100       0

If you create a lookup table off to the right indicating what "counts" begin what score level (see picture) then you can simply COUNT how many cells are >= to your target score in that lookup table and pull back the appropriate score.

Attached Images

VlookupScore.jpg (61.6 KB, 22 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3 Conditions	Laurie B.	Excel	4	08-15-2011 10:27 PM
how to set an equation with three conditions?	Jamal NUMAN	Word	0	07-09-2011 06:05 AM
Vlookup and If conditions together along with match formulas	david_benjamin	Excel	2	04-11-2011 11:30 AM
Count with multiple conditions	bundy5150	Excel	4	02-22-2011 10:00 AM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.