IF (CELL VALUE) > 0 and (Not #N/A) display date

[Mike Slattery]

I need to display a date found in cell CD3 if the value in cell DD3 is greater than zero. If cell DD3 contains #N/A I want the cell to display a blank or "".

I have tried If(and, If(or, ISNA, ISERROR. and even =IF(OR(DD3>0,DD3<>"#N/A")*CD3,"",)

Can someone please offer a suggestion. It seems simple explaining the problem but the double negative is confusing me.

Thanks, Michael

 

[oldbrewer]

something like if(iserror(dd3*dd3),"",if(dd3>0,cd3,""))

 

[Mike Slattery]

Hello OldBrewer:

That worked very well, Thanks, Michael

 

[Aladin Akyurek]

I need to display a date found in cell CD3 if the value in cell DD3 is greater than zero. If cell DD3 contains #N/A I want the cell to display a blank or "".

I have tried If(and, If(or, ISNA, ISERROR. and even =IF(OR(DD3>0,DD3<>"#N/A")*CD3,"",)

Can someone please offer a suggestion. It seems simple explaining the problem but the double negative is confusing me.

Thanks, Michael

Something like...

=IFERROR(IF(DD3>0,CD3),"")

=IF(ISNUMBER(1/DD3),IF(DD3>0,CD3,""),"")

 

[Mike Slattery]

Thanks again Aladin:

I at least understand yours, they both work however.

Michael

 

[Aladin Akyurek]

Thanks again Aladin:

I at least understand yours, they both work however.

Michael

You are welcome.