Friday, August 6, 2010

Web Trend

All for one and One for all.
Interactive / Feedback
Progressive / Offline
Responsive / Flexible

Tuesday, May 4, 2010

CorelDraw Shortcut Keyboard

Ctrl+N    New File
Ctrl+O    Open FIle
Ctrl+S    Save
Ctrl+Shift+S    Save As
Ctrl+I    Import
Ctrl+E    Export
Alt+F4    Exit (Keluar dari corel)

Friday, January 22, 2010

Error In Excel

#DIV/0!
when formula try to divide a number by 0 or empty cell or empty string.

### error
When your cell's column isn't wide enough to display the value.

#NAME? error
The #NAME? error occurs when Excel does not recognize a formula.

#VALUE! error
when a formula has the wrong type of argument for fill the formula's process or formula's calculate.

#REF! error
when a formula refers to a cell that is not valid or empty.

#N/A

#NULL

Formula:
IFERROR
ISERROR

Circular Reference

Floating Point Errors / Scientific Notation
rounding a number
ROUND
ROUNDUP
ROUNDDOWN
MROUND
chop or cut off floating point
INT
TRUNC

CEILING
FLOOR

EVEN
ODD