If or help needed

		Microsoft Office Forums > Microsoft Excel > Excel
If or help needed

FAQ

Thread Tools

Display Modes

07-29-2013, 11:30 PM

Pecoflyer

Windows 7 64bit If or help needed

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Perhaps try

Code:

=IF(SUMPRODUCT(--(I17:I11<J17:J11));1;0)

Which kind of values to you have in these cells ?

If this does not work please post a small sample sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If-Then help needed	sammipd	Mail Merge	1	04-24-2013 04:38 AM
Serious help needed.	karlyak22	Outlook	0	11-13-2011 07:32 AM
Frontpage help needed	ytryity	Misc	1	03-19-2011 09:07 AM
help needed!!!	thunder14	Word	1	10-17-2009 02:57 PM
Help needed :)	thechief55	PowerPoint	1	04-28-2009 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:39 PM.