Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you use two inequalities with the IF function ie IF 10 |
Excel Discussion (Misc queries) | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
Graphing inequalities | Excel Discussion (Misc queries) | |||
graph linear Algebra equations and inequalities | New Users to Excel | |||
Template for graphing algebra inequalities and easy to shade the . | Charts and Charting in Excel |