Hi,

Am Fri, 15 Feb 2013 12:51:03 +0000 schrieb EngAaron:

B3 = 80
B4 = 60
B5 = Cell Value

I would like a function that will export the following into :

IF B5 = B3 THEN "+"
IF B5<B3, B5B4 THEN " "
IF B5<= B4 THEN "-"

try:
=IF(B5=B3,"+",IF(AND(B5<B3,B5B4),"",IF(B5<=B4,"-","")))


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