hi all
i have
2 cells , cell a1 and a2
cell a1 can contain alphabets , numbers and all special characters
i want a formula if cell a1 contains any value or text than cell a2 will return "yes" else "no"
hi all
i have
2 cells , cell a1 and a2
cell a1 can contain alphabets , numbers and all special characters
i want a formula if cell a1 contains any value or text than cell a2 will return "yes" else "no"
hi kshitij_dch. so basically if A1 is not blank, then "yes"?
=IF(A1<>"","yes","no")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
yes but i want yes or no should come in cell a2
Hi
In cell A2, enter
=IF(LEN(A1),"yes","no")
--
Regards
Roger Govier
Microsoft Excel MVP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks