Blank cells with a max formula

[NikkiMc204]

Hi all,

Once again i'm asking for your help

I have this formula to work out the value difference. =MAX(E4-D4,0)

Column D Actuals	Column E Target	Target Not Met	Target Overachieved
1411​	1475​	64​	0​
1790​	1475​	0​	315​
1744​	1475​	0​	269​

My problem is when i have blank data in column d - i get target not met as 1475 - which i don't want as i'm trying to make an excel chart.

How can i get =MAX(E4-D4,0) to ignore blank cells or return a zero figure?

Any advice greatly received.

 

[Fluff]

How about

=IF(D4="",0,MAX(E4-D4,0))

 

[NikkiMc204]

that works

Thank you so much, i've been going down all kinds of deadends and i hate to concede with formulas. I knew there's be a simple solution.

Thank you.

 

[Fluff]

Glad to help & thanks for the feedback.