Good morning all,
I was just wonfering how to write an if function that refrence text ? What I have is a cell where you manually enter a text code and then I have an general overiding index and I want the indext to apear if there is no text in the first cell
Basucally lets say abc1 is my index can I write an If function that can read the absents of text ?
Thanks
Do you mean?
=IF(A1="","abc1",A1)
This checks if A1 is empty. If it is it inserts text "abc1", else it will insert what is in A1.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry thanks I got it to work righ atfter I posted this,
Thank you for taking the time.
Something like:
=IF(A1="","There's nothing in A1","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks