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


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553701

=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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553701

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

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553701