missing a parenthesis..

amlagu

New Member
Joined
Sep 11, 2014
Messages
15
I was kindly given this formula, but it says I'm missing a parenthesis.. any ideas?


=IF(AND(K6 > = DATEVALUE("05/10/2014"),"OVERDUE","")
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,523
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You only have one condition so you don't need AND:

=IF(K6 > = DATEVALUE("05/10/2014"),"OVERDUE","")
 

geofspa

New Member
Joined
Jan 7, 2012
Messages
28
Office Version
  1. 365
Platform
  1. Windows
I was kindly given this formula, but it says I'm missing a parenthesis.. any ideas?


=IF(AND(K6 > = DATEVALUE("05/10/2014"),"OVERDUE","")


There is no AND comparison you could remove "(AND". This would then return OVERDUE if the date in K6 was less than or equal to 05/10/2014

=IF(K6<=DATEVALUE("05/10/14"),"Overdue","")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top