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
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
=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
Google is your best friend!
Thanks for the help Bear. We have a German template but we are having trouble understanding their logic due to the cultural differences.
Ed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks