The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function not working.

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

IF function not working.

Resolved · High Priority · Version 2003

ReplyWed 24 Jun 2009, 09:24Delegate Gareth said...

IF function not working.

Hey

I have a bit of a problem with my If Function.

I have two dates in two seperate colums. in the format dd/mm/yyyy. The columns are W and Q.

I have input an If Function along the lines of =If (W2=Q2), "", "Re-allocate"

The problem i'm having is that when the two dates match in both columns the formula is still returning "Re-allocate".

I think the problem might lie with the formatting of column Q. The date shown is the date retrieved from a vlookup function, from another sheet, that includes a time of day as well such as 00:00:00. The v lookup is only returning the date however.

Any thoughts as to why this is not matching? or Excel not recognising the two as the same date?

Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 24 Jun 2009, 09:47Trainer Amanda said...

RE: IF function not working.

Hello Gareth

Thank you for your question.

Would it be possible for you to email in a copy of the spreadsheet (or a similar example), including the sheet that the vlookup data? If so please email to amanda

Kind regards
Amanda

ReplyWed 24 Jun 2009, 10:30Delegate Gareth said...

RE: IF function not working.

Thanks amanda. Example Copy sent.

ReplyWed 24 Jun 2009, 11:42Trainer Amanda said...

RE: IF function not working.

Hello Gareth

Thank you for sending through the spreadsheet.

I don't think that the problem lies in the formatting, I think it is to do with the fact that you are getting Excel to try and compare something that is a value (the date in column A) with something that is the result of a formula (the result of the lookup in column C) - you're not comparing apples with apples here.

I tried copying the date from column C and pasting it as a value in a different cell, and changing the IF function and then it worked. I can't think of an easy solution for this, but I hope this helps to explain why the formula isn't working as you expect.

Kind regards
Amanda

ReplyWed 24 Jun 2009, 12:24Delegate Gareth said...

RE: IF function not working.

Thanks Amanda

Im a bit confused by this one as it worked with the formula result and text date comparison yesterday!

I amended the tab the vlookup was collecting the data from this morning and now it no longer works!

Excel articles

· Update Your VAT Rates In Excel
· Benefits of learning about Excel charts
· Creating Top Tables With Excel
· How To Create An Excel Formula Using Data From Several Worksheets
· Become A Budding Picasso Using Excel

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

How can you show horizontal lines on Gantt chart views?