Hi Michael,

Am Tue, 28 May 2013 16:22:27 +0100 schrieb MichaelPK:

If a number in cell AX2 is between -5 and 10, I want there to be “10” in
cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in the
cell and not “10.”

try:
=AND(AX2-6,AX2<11)*10
or
=IF(AND(AX2-6,AX2<11),10,"")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2