Jul 24 2023 08:45 AM
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!
Jul 24 2023 08:50 AM
SolutionJul 25 2023 01:23 AM
Thank you! I fixed it just by adding iferror but your one is much easier! 🙂
Jul 24 2023 08:50 AM
Solution