Madness

Madness is a term that is thrown around a lot—he's mad, she's as mad as a cut snake—and it can mean that someone is enraged or excited or foolish or insane. Taking the later example what does it mean to be mad?