Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Unhappy Inequalities Function

All,

I am trying to create an If THEN statement in excel for inequalities.

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 "-"

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,”-“)))

Can someone please help me out?

Thank you very much!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Inequalities Function

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
  #3   Report Post  
Junior Member
 
Posts: 2
Smile

I figured it out...

The function to acheive this in excel is:

=IF(B5=B3,"+",IF(B5<=B4,"-",IF(AND(B5<B3,B5B4),"n","n")))
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you use two inequalities with the IF function ie IF 10 CRICKETERRY Excel Discussion (Misc queries) 5 May 18th 23 03:45 AM
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? SteveM Excel Programming 1 January 3rd 08 04:45 PM
Graphing inequalities miss meliss Excel Discussion (Misc queries) 1 April 30th 06 09:50 AM
graph linear Algebra equations and inequalities Roxxanna New Users to Excel 1 May 18th 05 02:40 AM
Template for graphing algebra inequalities and easy to shade the . firetrk Charts and Charting in Excel 1 March 17th 05 05:57 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"