SOLVED

#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"

 

=if(and(isblank(j3),isblank(g3)),"",if(and(not(isblank(g3)),isblank(j3)),g3-b1,"Done"))

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

Hope someone can help, many thanks!

2 Replies
best response confirmed by SergeiBaklan (MVP)
Solution

@poje12

Try

 

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

@HansVogelaar 

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

1 best response

Accepted Solutions
best response confirmed by SergeiBaklan (MVP)
Solution

@poje12

Try

 

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

View solution in original post