Help with If and AND

[Sean15]

Hi:

Formula is P18 is returning "" and I don't know why. Formula should return "add 175"

Data range is a pivot table.

Could you help please?

Excel 2010
	N	O	P
14
15	Account	2010106
16
17	Row Labels	Sum of Amt
18	01/02/18	125.00
19	02/01/18	860.00
20	03/01/18	225.00
21	Grand Total	1,210.00
22
23
Sheet1

Cell Formulas
Range	Formula
P18	=IF(AND($O$15="2010106",N18=DATEVALUE("01/02/18")),"add 175","")

Regards,
Sean

 

[vcoolio]

Hello Sean,

In the formula, try removing the quotation marks from around 2010106.

Cheerio,
vcoolio.

 

[Sean15]

Hi:

That works, thanks very much.

Regards,

Sean

 

[Trebor76]

Hi Sean15,

This works for me:

=IF(AND($O$15=2010106,DATEVALUE(TEXT(N18,"dd/mm/yy"))=DATEVALUE("01/02/18")),"add 175","")

Note the entry in cell O15 is numeric and the entry in cell N18 is an actual date.

HTH

Robert

 

[vcoolio]

You're welcome Sean.
I'm glad to have been able to help.
@robert:-

Good approach to the issue. Its a more robust method.

Cheerio,
vcoolio.

 

[Trebor76]

Hi vcoolio,

Thanks for that and the like

Regards,

Robert