Auto_Open

[Hui]

I've emailed you

 

[sgmpatnaik]

Hello Ninja Sir


i am waiting for your mail

 

[sgmpatnaik]

Hello Ninja Sir


Please check your mail

 

[sgmpatnaik]

Hello Ninja Sir


is there any suggestions for me

 

[Luke M]

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"))

 

[Hui]

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...