Atau =Max( 1, E14-D14 ) Wassalam, Kid.
2013/12/17 Bagus <ba...@kingjim.co.id> > > > Hai Tio; > > Coba begini: > =IF(E14-D14=0,1,E14-D14) > > Copas kebawah > > > Wassalam > > ~ Bagus ~ > > > > ----- Original Message ----- > *From:* Syalom Tio <laser_h...@yahoo.com> > *To:* belajar-excel@yahoogroups.com > *Sent:* Tuesday, December 17, 2013 12:20 PM > *Subject:* [belajar-excel] Laporan Hotel [1 Attachment] > > > > Dear BeExceller > > Gimana agar lama menginap jika 0 dapat terhitung 1 hari. > file terlampir > > Thx. > > TIO > > >