mercredi 7 mars 2018

Excel: Return value blank and i want to keep it blank or empty

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