8 levels or more IF function for EXCEL 2003 or below

"the specified formula cannot be entered because it uses more levels than are allowed in the current file format"

For those who actively use Microsoft Excel, may had found the error statement above. It caused by the limitation of nesting level of older version of the application (2003 and below). They only support up to 7 nesting level of a function in one statement.

There are some alternative ways to get around, here's some of them:

1. Upgrade your EXCEL to 2005 or above.
2. If you had a macro programming skill, create a function in VBA.
3. or, you can split the function up to some parts.

Here, we'll try the last option, Split up the function.

I have this function that had the nesting level issue:

=IF(H6<91.5%,40%,if(h6<92.5%,35%,if(h6<93.5%,30%,if(h6<94.5%,25%,if(h6<95.5,20%,if(h6<96.5%,16%,if(h6<97.5%,12%,if(h6<98.5%,8%,if(H6<99.5%,4%,0%)))))))))

as the limitation goes, than the function will only work if we cut the red part off:

...if(H6<99.5%,4%,0%)...

But that won't solve the problem. So, I came up with this way.

• Take the 8th level of nesting out (let's say use the C2 cell) and exchange it with "FALSE" value, so the function will look like this:

=IF(H6<91.5%,40%,if(h6<92.5%,35%,if(h6<93.5%,30%,if(h6<94.5%,25%,if(h6<95.5,20%,if(h6<96.5%,16%,if(h6<97.5%,12%,if(h6<98.5%,8%,FALSE))))))))

• Put the 8th IF to another cell and put another IF statement before it to check the output value of the IF statement above (from the C2 cell). If it return FALSE then execute the 8th IF. So the second part of the function will be like this:

=IF($C2=FALSE,IF(H6<99.5%,4%,0%))

• The last part is to choose which output to use. Here we'll use another IF. Check whether the return value of the first statement is FALSE or not. If it is, then use the return value of the second if statement. If not, then just use the value. Here's what it would be like:

=IF($C2=FALSE,$D2,$C2)

There you go! We finally made it. Hope you'll find this article useful. If you want to see the real example of the EXCEL format, I have uploaded it here. Have a good day!

Windows Vista Hibernate Feature

I recently upgraded my OS to Vista (as one can see on one of my previous post). The elegant look-and-feel and better security -or so they claimed- had made me to take this journey (har..har...har...). I know but a bit about the Security issues, but the look-and-feel is one thing for certain. If you talked about ease-of-use, one can say that it's about fifty-fifty, like I found it easy to connect to a network but it's a walk-in-a-maze to find out how to tweak the setting.

I'm mobile and I need my laptop to boot-up and shut-down faster. If I were to follow the normal sequence of powering-up and shutting-down, it'll take forever. So I've found this HIBERNATE feature on XP litterally cut-the-middle-man. It could cut up until half of the time I'd needed on those routines.

But...! This won't happened on my Vista...!!!

Like I said earlier, I really went on a maze with Vista trying to find the setting I need, but came up with nothing but frustration. So I turned to my beloved uncle google and found out that Vista is no longer giving it's users the luxury to enable or disable hibernation via desktop graphical user interface.

So here's how to re-enable it:

1. Type cmd into your Vista's Start Menu Search Box, and use Ctrl+Shift+Enter or you can also right-click the item in the menu and choose Run as Administrator to open in administrator mode.
2. Type in the command powercfg -h on in the appearing command prompt window.
3. You're Done...! Here's the screen shots of before-and-after the process.
   

Before

After

And if you ever want to turn it off again, well... I think you can guess what to type in. (^_^)

Note: Here's what Microsoft has to say

[Info] Skype. Is it ready to take over?

This Friday one of my friend suddenly pop-up with an interesting Q. "Got a Skype?", off course I said "No! And what the heck was it for?" and this successfully made me one of those old-timer, really! Since the first one came up in my mind after the Q was a a tool for having a phone-like call via the net or VoIP (Voice over Internet Protocol) to the regular phone line. Plus, we have to buy some credit to do the call. Never in my mind had I imagined that this tool evolved into some kind of user-killer software that can be a threat to YM in the internet relay chat software competition.
After some browse of the net to help me out from my cluelessness, I did find out it really is happening. Let's have some quote on what other have said:

• Kualitas suaranya hampir sama dengan menggunakan telepon. Bedanya kalau telepon saya tidak didepan komputer, sedangkan dengan skype saya bisa lansung melihat apa yang sedang dibicarakan, atau ditanyakan karena sama sama berada didepan komputer. (http://kerjakeras.com/chatting-dengan-skype-vs-yahoo-messenger/)

• Secara garis besar Skype lebih unggul dibandingkan software lainnya dalam hal kualitas suara pada voice call. Selain tersedia versi Linux, Skype juga menyimpan call & chat history secara otomatis. (http://akatelsp.ac.id/2009/01/07/infokom/manfaat-skype/)

• It doesn't attempt to take over your computer when you install it; Setup is easy; Sound quality is great; All of the above could be said about Skype 18 months ago (the post dated back on Oct. 10, 2005). (http://www.techzonez.com/forums/showpost.php?s=ca8d238d967170c7515fef41acec438e&p=105428&postcount=8)

• Yahoo is trying to do too much in one Messenger tool. Messenger is now too powerful, heavy and overloaded. As I rarely use instant messaging, I just want a tool to make phone calls and maybe chat occasionally, Skype is the superior software if you are just making phone calls; Skype has a Linux version. To the best of my knowledge Yahoo Voice has no Linux option. (http://www.harshadoak.com/2006/09/internet/skype-out-vs-yahoo-voice-service-review-and-comparison.html)

Well...those are the comments. Overall, they seems to be agreed that Skype has better quality on the voice call feature over YM. That's not so surprising though, seeing that Skype was started for making a cheap long-distant voice-call solution.

If you wanna know what aunty Wiki has to say about this Skype, please visit her @ her home here http://id.wikipedia.org/wiki/Skype.

Those are what I came-up with from the net, but personally I think that I'll stick to the old-glorious Yahoo! Messenger for now because I'm a typing type rather than a talky one *hehehe* Still, the choice is yours...

Finally, for those who having trouble downloading the latest Skype for windows software, I've made some mirror here and the other alternative here. Both files are packed with RAR format and have to be extracted first with either WinRAR or other RAR applications. If you don't have one, you can get WinRAR v3.51 here.

Woahh...! I made my Windows record...!!!

Dated as 7/7/2009 11:25 AM I've made a coincidental BREAKTHROUGH (as the saying goes :-P), with >57 active windows are opened on my office Laptop He...he...he....
Detailed as:

• 52 Internet Explorer 8 Beta, each with active Windows Live Hotmail
• 2 Yahoo Messenger 9 windows
• 1 Windows Paint
  
• 1 Total Commander 7
• 1 Firefox 3.0.10 with 4 active tabs
• 1 FlashGet, running in the back.

All are active within Windows Vista Premium with Aero and Sidebar feature activated.
And my Laptop specs are:

• Acer Aspire 4720Z
• with 1 GB DDR2 RAM
• 120 GB Hard Drive total capacity
• etc.

Guess this should be celebrated somehow since it's Micros*ft Wind*ws for god sake (yeah go on... ):

[Tricks] Repeat Print Table Header or Footer with CSS

If you guys ever stumble upon how to get the table header/footer repeat it-self when printed, so I guess this trick here could helped you to just figure it how.

---

---

Well... There you go....!

Good luck... ^__^