#value error

Copper Contributor

I need to make this formula

if g3 and j3 are blank then h3 is blank.

if g3 has a date and j3 is blank then h3=g3-b1.

if g3 has a date and j3 has a date then h3="Done"



this is my formula but I don't understand the problem! 

Hope someone can help, many thanks!

2 Replies
best response confirmed by Sergei Baklan (MVP)




=IF(G3="", "", IF(J3="", G3-B1, "Done"))

@Hans Vogelaar 

Thank you! I fixed it just by adding iferror but your one is much easier! :)