How can I make an IF-formula to say: if(g8=anything,"Y","N"). I don't want the word "anything", I just want it to calculate when there is any text in that cell.
Thanks.
How can I make an IF-formula to say: if(g8=anything,"Y","N"). I don't want the word "anything", I just want it to calculate when there is any text in that cell.
Thanks.
=IF(G8<>"","Y","N")
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
Awesome, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks