I can't seem to get this formula to work, it gives me a #VALUE. My answer
should be 1, what i'm asking is, if it says Creative in Col A, and Col E has
data for those Creative rows, then place a 1 in the cell, if not place a 0

=IF(A23:A90="Creative",MAX((K23:K90)0.001,1,0),0) answer should = 1
=IF(A23:A90="Advertising",MAX((K23:K90)0.001,1,0) ,0) answer should = 0
=IF(A23:A90="Creative",MAX((K23:K90)0.001,1,0),0) answer should = 1
Col A Col E
Creative .25
Creative empty
Creative .25
Advertising empty
Advertising empty
DG .10
DG .10