Hi- I need a formula with the following criteria in the attached spreadsheet example:
On column E if column A is equal to ABZ or SOL then I need to get the six right characters from column C.
However, if column C if empty for ABZ or SOL then I need to get the six right characters from Column B.
If not meet with any of this criteria then column E should be blank
Thank you.
Last edited by Ladyj07; 03-25-2024 at 03:36 PM.
In E2 then drag down:
=IF(OR(A2="ABZ",A2="SOL"),RIGHT(C2,6),RIGHT(B2,6))
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
@Dosydos is there a way to get blanks if not meet with the any of the criteria I mentioned above. For example if is not ABZ or SOL then I want column E to be blank
Try this.
Are you sure that you want the 6 characters from the right?
Formula:
Please Login or Register to view this content.
Last edited by DJunqueira; 03-25-2024 at 03:41 PM.
What do you want if column A is not "ABZ" or "SOL"
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
@Popipipo I want to be blank if not meet with the criteria
try this in E2 and drag down:
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you @dosydos and @John Topley!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks