it doesn't work because i forgot to mention that actually C97 has a formula but result is 0 (is taking ='MAIN DB'!B23)
when i use your formula =IF(C97="","",MDB_MEL!Q36) i put 0 in the "" but still nothing

thanks for the quick respond