May 02 2024 04:12 AM
I am trying to write a function that will look up if the last character in A column is "D" or "L" and if this is the case will then move the last character to G column. When i try to enter the formula shown it shows #Value error, is there a way to fix this formula?
May 02 2024 04:19 AM
Solution
On G1 place:
=IF(OR(RIGHT(A1,1)="L",RIGHT(A1,1)="D"),RIGHT(A1,1),"")
Drag down to fill all cells.
May 02 2024 04:22 AM
May 02 2024 04:47 AM
May 02 2024 04:19 AM
Solution
On G1 place:
=IF(OR(RIGHT(A1,1)="L",RIGHT(A1,1)="D"),RIGHT(A1,1),"")
Drag down to fill all cells.