Hi, is there a way I can do the following.
I want a formula to basically do.
"in cell b1, If cell A1 contains either of the words Apples or Oranges then write Apples&Orange, otherwise = contents A1
Hi, is there a way I can do the following.
I want a formula to basically do.
"in cell b1, If cell A1 contains either of the words Apples or Oranges then write Apples&Orange, otherwise = contents A1
Try -
=if(or(A1="Apples",A1="Oranges"),"Apples&Orange",A1)
Dave H
- Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
- Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Maybe this
Formula:Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
=IF(OR(A1="Apples",A1="Oranges"),"Apples & Orange",A1)
Thanks that is great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks