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?
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?