View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Inequalities Function

"EngAaron" wrote:
I would like a function that will export the following into :
IF B5 = B3 THEN "+"
IF B5<B3, B5B4 THEN " "
IF B5<= B4 THEN "-"
This is the function that I currently have and it does not work:
=IF(B5=B$3,"+",IF(AND(B5B$4,B5<B$3),"",IF(B5<=B$ 4,"-")))


You are over-specifying. Try:

=IF(B5=B$3,"+",IF(B5B$4,"","-"))

In the second test, we do not need AND(B5<$B3,...). That is implied by the
fact that B5=B3 is false.

Similarly, the third test is not needed. That is implied by the fact that
B5B4 is false.