Forum Discussion

poje12's avatar
poje12
Copper Contributor
Jul 24, 2023

#value error

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),isbla...
Excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 24, 2023

    poje12

    Try

     

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

poje12's avatar
poje12
Copper Contributor
Jul 25, 2023

HansVogelaar 

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

Resources