Be sure the number type on the HOME tab is set to "General", or "Number". Not TEXT. Then, in the formula bar, press "enter" after your formula to accept and it'll calculate.

Pete