To keep it short i have this if IF statement:
=IF(AND(MOD(Sheet1!AY9,1)>TIMEVALUE("11:00"),MOD(Sheet1!AY9,1)<TIMEVALUE("11:59")),sheet2!D8,Sheet1!W5)
the return of sheet2!D8 some time is 0 and some time is empty but it convert the empty to 0. My issue is when returns empty i want it to be empty not 0.
thanks for helping
Aucun commentaire:
Enregistrer un commentaire