Logic please

C

changetires

Can someone tell me the logic behind this formula. Wasser means water
in german.

=IF(OR(C11="",G11=""),"",IF(LEFT(B11,6)="wasser",0,(G11-C11)*24))

Thanks

Ed
 
B

Bearacade

=IF(OR(C11="",G11=""),"",IF(LEFT(B11,6)="wasser",0 ,(G11-C11)*24))

If C11 or G11 is blank, then left the cell blank

If the first six letter of B11 is WASSER, then cell is 0

else (basically if C11 or G11 is not blank or B11's first six letter
isn't WASSER) let the cell be (G11-C11)*24
 
C

changetires

Thanks for the help Bear. We have a German template but we are having
trouble understanding their logic due to the cultural differences.

Ed
 
Top