EXCEL FORMULA TROUBLE SHOOT
Budget: ₹600 – ₹1,500 INR
I have following formula in my Excel Sheet:
IF(ISNUMBER(SEARCH("LOADING";H6)); $B$6;"")
It checks if the above CELL contains the word "Loading" and then determines the value if it does and leaves cell blank if it doesn't.
Now, I want the same formula to search for the word "loading" on the Cell above, and also check the cell adjacent left to the cell above. If both cells contain the word loading, then I want the Formula to calculate the SUM of 3 CELLS if only the cell above contains the word "loading, then the value to be another cell if only cell above contains word "LOADING", and blank if none of the cells above contains the word "Loading"
On attached Spreadsheet.
a) If Cell H6 contains the work "LOADING", then the value in H7 is equal to CELL B6 (25-05-23 00:00), and if H6 does not contain the word "LOADING" then H7 remains Blank.
Now I want to have a function that:
Performs same as function a) but also considers if both H6 and G6 both contain the word "LOADING", then return the value (B6+D7+E9) - This would be the case with i10 J10 where I want to run Formula a) but since both CELLS J10 and I10 contain the world "LOADING" then I want J11 to be Equal to B10 + D11 + E13).
Thank you
IF(ISNUMBER(SEARCH("LOADING";H6)); $B$6;"")
It checks if the above CELL contains the word "Loading" and then determines the value if it does and leaves cell blank if it doesn't.
Now, I want the same formula to search for the word "loading" on the Cell above, and also check the cell adjacent left to the cell above. If both cells contain the word loading, then I want the Formula to calculate the SUM of 3 CELLS if only the cell above contains the word "loading, then the value to be another cell if only cell above contains word "LOADING", and blank if none of the cells above contains the word "Loading"
On attached Spreadsheet.
a) If Cell H6 contains the work "LOADING", then the value in H7 is equal to CELL B6 (25-05-23 00:00), and if H6 does not contain the word "LOADING" then H7 remains Blank.
Now I want to have a function that:
Performs same as function a) but also considers if both H6 and G6 both contain the word "LOADING", then return the value (B6+D7+E9) - This would be the case with i10 J10 where I want to run Formula a) but since both CELLS J10 and I10 contain the world "LOADING" then I want J11 to be Equal to B10 + D11 + E13).
Thank you