Excel

[ansari_aiyaz]

i put =IF((E41-D41)>8,8,(E41-D41))*24-9 this formula when input given. But when input not given it show -9 so i need to remain empty cell if input empty. Please correct this

[#2]

@ansari_aiyaz 

That would be

=IF(OR(D41="",E41=""),"",IF((E41-D41)>8,8,(E41-D41))*24-9)

But I'm not sure that the formula does what you want...