thanks sky... but your IF formula is for qn1 or 2

hmmm then what's the condition?

EXCEL 03/07 PROS - Please help me. I'm working on an assignment and the teacher gave us questions whereby we have to find formulas to use to solve it when we havent learn it the first place. Stucked with two functions.

1) Cinema Seating. Have a cell table listing the different seating types (A), field to enter seat location (B), pricing table for different sectors (C). How to click on any area in (A) then display in (B) then display correct price in (C). Displaying price is it use VLOOKUP? If not?

2) It's a loan amortisation table so this table shows the payments from month 1 to month 60 ie 60 rows.  I've set up the table to calculate the payments, depending on the amount of years i want to take to pay the loan. Question being how can i let the subsequent months (rows) be blanked out if say loan takes 4 years - 49 months (49th row) onwards blank out. 3 years, 37th row onwards blank out. Tried conditonal formatting but it doesn't work.

i don't have any visuals now so it's abit hard to relate. anyway, just like to ask all you guys/gals out there about guys hairstyle...

how to cut or maintain the hairstyle where by the sides are pretty thin and then the middle is like very thin and spiky outwards one. dont need gel/wax also looks very nice and natural?

problem is my hair alw grows v thick and i dont know how to describe that kinda hairstyle to stylists. shrugs.

Hey anyone watching solitary now? My... It's taking reality TV show to the next level man, seeing the truest colours of human beings under such trying situations. It's abit sadistic though.

Originally posted by nehpyh:

Qns:

1. What apps did you turned on?

2. What apps are running in the background?

3. MBP is at least a duo-core and it needs more juice to do just even powering it up.

4. Your MBP battery is already 1.5 yr old. If you use it daily and heavily, it'll weaken like everything on earth.

5. You didn't say your MBP is a 15" or 17". The bigger the greater the power sapping.

6. Did you maintain your battery with complete drain and full charging?

 

As a consolation, my G4 Power Book is 7 year old and the sole original battery can still last 1hr.

1. apps normall on like mac office, mozilla

2. airport?

5. mine's a 15"

6. complete drain and full charging not consistently practised.

 

so how shld i go about resolving the problem?

hello... my macbook pro is about 1.5 years old. and the current battery life when fully charged displays around 1h 40+mins when i put the settings to best energy performance and half of the brightness bar. Kinda sux because w/o running for long, i gotta find a power source already.

how can i resolve this problem? get a new battery so at least i'll get the 4-4.5h battery life APPLE claims? or is it the problem of my macbook pro itself? and the thing is im not covered under warranty.

yeah and i gotta take stats exemption test somemore. mati.

well. i would like to know why he has this belief that knowing how to trade can land him in IB too.

Originally posted by Ray87:

thousandisland, i believe i'm quite aligned with what you are feeling now. Just turned 21 and waiting to get into a university in 2 months. These questions have been drifting in my mind for a quite some time already, i myself have not found a clear direction.

However, I believe the mission in life relates to how your existance in this world is valuable to the rest of our community. It is something that we slowly explore and discover, and gets more refined as we experience and grow. Bringing happiness to your family and friends is just but a way to satisfy emotional needs, it cannot constitue to your personal mission in life. Contribution to others and personal mission has its differences.

Your personal mission has the capacity and potential to influence people at large, because contribution in lined with mission is supported by an endless stream of emotional energy that drives actions, and recharges itself as a consequence of your actions. Personal mission drives you towards success and emotional fulfilment.

I also believe that working for another person will not get you closer to your mission. When you are working, you are providing value to the top management, your value and contribution would always be limited by how the system in the organisation work. The top management are the people who are the one in lined with their missions and bringing value to the community, not you. When you limit your freedom to serve, you limit tremendous amount of potential value you could bring to your community, and thus the community will not reward you back with the big paycheck. Your life will be dependent on the paycheck of your employer, and you will never be free.

However in this society we live in, many will question and challenge the practicality of minding your own business. Many are heldback by the fear of uncertainty and rejection that comes along with serving the community at large. The prospect of not having a stable paycheck and facing rejection that comes along with it is real. But if you are truly keen on finding that path, you will find courage to break away from the main steam ideals, and become the few people in their lifetime to have found durable filfulment; people who can smile in their deathbed because they know they have fulfilled the reason for existance in this world.

I'm personally from a low income family and have secured myself a double degree programme in NTU. However, i also recognise that getting myself a high paying job in the future will not drive me towards my mission.

I believe, to find your mission out, you must first overcome your fears which dictates your future actions. Simply because a mission drafts actions as a consequence to serve, not as a consequence of fears.

Very intriguing and insightful. That being said, I'm too like you searching for the mission of our lives.

 Especially agree with your 4th para on not working for others. That's why my parents always frown upon my desires not to commit to a 9-5 office work solely for the fat pay cheque. But to quell their "fears", i'm just going through the motion to get a bachelors and then forge my paths ahead.

Interestingly, i have friends from both spectrums. One of them are contended with status quo for now and perhaps for dont know how many years to come. The other has friends who have lofty ambitions but are obviously not rooted to the ground.

Take for e.g. one friend of mine who's in sunshine empire (and now, emmax). I don't want to bring in the whole debate on MLM but apparently he thinks his "comrades" in SE are the most ideal business partners he can find. Almost everytime i meet him, he will be sharing about his grandeur business plans. Well, he said he's seen James Phang in flesh and has faith in the emmax platform.

Worse thing, he told me that university education is totally worthless and the only point he's studying is to pacify his parents. That being said, i need to qualify that although i haven't started my education in uni, i believe the rigorous training in terms of thinking and the exposure is a prep for my life ahead.

To make things more interesting, he's also qt a seminar junkie going for national achiever's congress and an upcoming forex course. He told me after graduating from the forex course, he will receive a trader's cert. Said that will be equivalent to a MBA and that will grant him better chance into an investment bank. I can't help but feel skeptical about his claims.

At the end of the day, in the capacity of his friend, I'll still wish him all the best in whatever he does. If he falls and licks his wounds, i will fetch him some tissues. If he rises above the rest, i'll be happy for him deep down.

Ultimately, for myself my fears driving my search - i don't want to be in either spectrum. I don't want to contend with a life I'm not interested in, considering we both are already in our quarter life crisises. Neither do i want to rush into believing i've foudn my first pot of gold and acting motivated. I like to believe true motivation comes innately.

So till then, i guess we'll still be searching.

Originally posted by alfagal:

who will wanna take in fresh grad to b investment banker?

u are handling cm profile of abv 1-3mil..

u still have to start somewhere..much lower....

income comes w sacrifices: sleep, weekends, after office hrs, committment, mental focusness...

i'm not talking about the short term, but more about an eventuality. i'm talking about the end of the rat race, when i've slogged my guts out for the next 10-15 years, getting my fat pay cheque. will i be happy? hope i didn't sound myopic for you to have the misconception.

purpledragon84: thks for e consolation.

 

 

Originally posted by purpledragon84:

i think u have answered ur own question.. our surroundings are always changing, and the people ard us are always changing.. therefore, our plans, our goals, these are always changing.. 

ur life may be working working working, but what u do after working is also important..

for a change, do something u have always wanted to do.. make an impact in the lives of ppl ard u... maybe that will lead to something more.. new events in ur life pushes u forward..

that notwithstanding, i still believe if you want to lead a fulfilled life, your goal in life should be unwavering. yes, the paths you take may change but ultimately the destination should be constant. isn't it so?

i've been doing so many different things in my recent years. experienced couple of up and downs that ppl my age wouldn't have. but i'm still actively in search for answers.

alfagal: i mean Investment Banker

i reckon you won't be thinking of ORD all your life.

Just curious, how many of you here think you have found your true calling? That is to say,

1) you are doing the work that makes you leap out of bed every morning...

2) you are  doing what you love and loving what you do

3)  your work satifys a need deep within to express yourself, your talents, your values, your unique and precious gifts?

I don't know if i'm worrying unduly. But i'm about to attain my passport of freedom i.e. 21 in about 5 months to come. And in 2 months to come, i'll be studying accountancy at a local u in 2 months. Even so, I aspire to be a banker, i believe that aspiration stems from the prestige and potential income that comes and not exactly from somewhere innated.

In this few months, i've been seeing so many different people. Some feeling lost in their late 20s, early 30s... still searching for their reason of existence. They've changed their career paths so many times and think their work is just work and not their career. They feel dismotivated and dread the routine.

And so, i just sat at the park alone just now for the past 2 hours, thinking of what i really want to do. Life is really so short and i guess like many of you, i don't really want to live life like a lost sheep till i hit the cradle. Feeling quite heavy so i thought i asked around here.

Has anyone of you found your true calling? If so, what has guided you towards finding it?

thanks for the feedback so far. if taking into account debit cards (esp uob, citibank) that can function as ezlink, debit and atm card. what can possibly deter you from choosing the debit or encourage you to use this student privilege card?

hello everyone! my friends and i have an idea though it's pretty stale and over-used. bascially there's a student privilege card in our sch (smu) and as per normal privilege cards they have tie-ups with different merchants and all.

 

We are thinking of creating a student card for students, targetting upper sec students to tertiary students (age from 15-24) just that it's not instituition or merchant specific.

 

therefore will appreciate if you all can provide me some feedback, be it whether you are currently a student or not! =)

 

1) If there's a student privilege card that will provide you discounts/rebates for f&b (cafes, fast food joints, pubs, clubs), entertainment (movies, arcades, theme parks), cultural & learning (self improvement, dance, music, arts, drama, financial literacy), wellness (mani/pedi-cure, spa, facial, skincare, fitness, nutritional supplements) all under one card. Will you be interested? If yes, how much are you willing to pay per annum?

 

2) If no, what will actually entice you to purchase this card?

 

Will appreciate any honest feedback! Thanks for your time people.

plz dont sign on.

liu xiao ming a.k.a ah bao already finished already.

now is cpt ouyang again =D

wah go dfs buy 21 bucks can resale 2x. gd money, i shld have bought it when i was at airport too.

i taking acc at smu, was planning to major in law. gosh. walesa, am i entitled to advice too? hah.

Originally posted by whiskers:

This shows that 30% of singaporeans live below $700 percapital income... Very bad stats for a first world country i would say?

that's very bad inferencing skills you have. poorer 30 % does not equate to all having <700 in income. <700 in income, is possibly a subset of 30% and not an entirety -_-.

dont know if you're posting on the right forum, but anw... think you'll find better luck at youth.sg forums. not to be skeptical, but i've seen enough threads to have a "somewhat" absymal impression of the level of social concern among youths, especially in terms of volunteering.

Originally posted by ndmmxiaomayi:

My favourite - http://www.cgsecurity.org/wiki/PhotoRec

But you need quite a lot of technical skills as it doesn't have a GUI.

xiaomayi... i read the wiki... besides my hdd it can't detech my camera SD even though it's connected. any solutions?

anyone... i connected my camera to desktop can detect but not as a physical drive. hence all the above recovery methods dont work even the DOS base one... will i require a sd card reader?

yah. apparently some problems with connecting to my mac. guess gotta go back to sg and try with desktop.

all these softwares for camera SD cards right?

thanks a lot leh.