• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto_Open

sgmpatnaik,


Be aware that Hui is from Australia, and so may be sleeping at this time. As I stated before, he nor anyone of us are obligated to help out; it is all on a volunteer basis.


If you'd like the rest of us to help, you could explain what it not working when you use Hui's formula:

=IF(C2=1,"Party Name",IF(C2=2,"Party Name",IF(C2=3,"Party Name",IF(C2=4,"Party Name",IF(C2=5,"Party Name",IF(C2=0,"-",IF(C2>5,"Party Not Created")))))))


Are you getting an error, wrong values, wrong values in some cells?


Looking at formula, it could be simplified to:

=IF(C2=0,"-",IF(C2>5,"Party Not Created","Part Name"))
 
SP


I have just emailed you


Your comments are not matching the file you sent me ?


Please clarify via email


There is no need to keep posting here


Hui...
 
Back
Top