Hi and Happy 2016!
I need a formula that will return N if the referred cell is blank or if it is 0. If the referred cell has data then it should return Y. My formula IF(A2>0, “Y, “N”) is returning the N and Y correctly when A2 has data. When A2 is blank, it returns Y. FYI, A2 is a formula cell i.e. the data in A2 is based on a formula.
Thanks.
SP
=if(A2="","N","Y")
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
That gives Y with a 0.
Try:
=IF(OR(A2="",A2=0),"N","Y")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
answered same as posted earlier by ConneXionLost and Glenn as page could not refresh and I saw last post only.
Last edited by hemesh; 01-13-2016 at 01:32 PM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
...which, in turn, was the same as ConnexionLost's !!!
@ Glenn I edited post 5, I really could not see that!
Thank you all for your quick and great responses. The formula works well.
SP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks