If cell is blank do not put value of $0 but instead leave cell blank

[WBURNS]

Help!!!!

I have copied the folowing equation from a different spreadsheet. I did not know how to write it myself.

Current equation if cell f23
=if(and(isnumber(d23),d23>0,isnumber(e23),e23>0),d23*e23,if(and(isnumber(d23),d23>0,istext(e23)),"tbd",0))

right now if cell d23 is blank then cell f23 shows a value of $0.

What do i add to the current equation that says if d23 is blank then f23 should be blank?

 

[etaf]

just add
=if( d23 = "" , "" ,

=if( d23 = "" , "" , if(and(isnumber(d23),d23 > 0,isnumber(e23),e23 > 0),d23*e23,if(and(isnumber(d23),d23 > 0,istext(e23)),"tbd",0)))

 

[WBURNS]

Thanks etaf.

Worked perfect!

 

[etaf]

you are welcome