Forum Discussion
Excel Data Extraction with condition.
Hi All I am Working on the Excel data where I created column based on the value's from other colum as shown below. 2hrLoadEndTime is as New Column created with if condition =IF(A...
=IF(AND(ISBLANK([@[End Time]]),[@[Load Status-1]] = "Skipped"),[@[Start Time]]+(1/24),VALUE([@[End Time]]))
or
=IF(AND(ISBLANK([@[End Time]]),[@[Load Status-1]] = "Skipped"),[@[Start Time]]+"1:00",VALUE([@[End Time]]))
Juliano-PetrukioFirst one worked for me and regarding solution I got it by using xlookup function