If statement results in #VALUE!

[still learning]

Hi
I'm having a brain fart

A433 has a date in it formatted as mm/dd/yy

I put this in G433 and got #VALUE !

=IF(AND(A433="",""),IF(A433>=TODAY(),"pending","payment"))

What don't I see??

Mike

 

[AhoyNC]

Try:

Excel Workbook
	A	B
433	3/20/2018	payment
Sheet

 

[still learning]

Hi AhoyNC,

Ah..I didn't need the AND

I had copied it from a different if statement on the same sheet that had "AND" because it had multiple conditions for each condition.

Maybe I should not have tried this after some ****tails

Thank You
mike