Function to return MAX value for a range

Originally Posted by NBVC

=MAX(E2:CA2)

I tried that but it returns $0 even when the employee has $40 showing for several months....I've tried so many combinations that I've become very confused...thus I needed you guys to help me out.