Excel loves back!!
Posted by: hephz on: January 30, 2009
Jennifer was asking the bunch of us if anyone is good with the excel =if formula and I happily told her I can do some simple ones.
I found out later that she wanted a pretty complicated formula which I thought was impossible at first. It got me very curious and I started googling for a similar situation. I found 1 after spending ard 30 mins lurking in the internet. Spent another 15 mins editing & testing the formula.
I think I shouted Huat Ah when I got it right… Haha!!
The formula looks something like this:
=IF(AND(J3=0),”0″,(IF((OR((SUM(J1,J3)*J$5>650))),”650″,SUM(J1,J3)*J$5)))
Wah Piang, the 满足感 is 1000000 x 1000000 la!!!
I love Excel and Excel loves me!!
2 Responses to "Excel loves back!!"
January 31, 2009 at 17:04
Ok, after my ACCA I go take a dip in programming…
Wahahaha!! I think it’s damn satisfying la!!
Leave a Reply
Recent Comments
 | marvin on 2nd Kelong Trip |
| Hephz on Excel loves back!! |
| Adrian on Excel loves back!! |
| Marco Crupi on CNY Related~ |
| iinsanity on Home Visit? |
| Hephz on Home Visit? |
| iinsanity on Home Visit? |
| Amina on Of Exams & Taxi Drive… |
| sarah on John’s Wedding |
| Hephz on Updates!! |
| faith Mok on Updates!! |
| Hephz on Opening for GF |
| pinkliciouz on Opening for GF |
| sarah on Donate Blood & various ran… |
| Adrian on Ah Bee’s Birthday |
January 31, 2009 at 15:44
If that sort of thing floats your boat, you should have gone into programming.