| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using if statements
I am trying to use this if statement:
IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")), the problem is I can not figure out how to tell it if the answer is greater than 0, put in the number and not J8*J25-J10*J25, can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statements
Remove the quotes form the ELSE argument.
=IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,J8*J25-J10*J25)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "LAybar" wrote in message ... I am trying to use this if statement: IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")), the problem is I can not figure out how to tell it if the answer is greater than 0, put in the number and not J8*J25-J10*J25, can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statements
Chip,
Thank you, I have been staring at this for so long, I just could not see what the problem was!!! "Chip Pearson" wrote: Remove the quotes form the ELSE argument. =IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,J8*J25-J10*J25)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "LAybar" wrote in message ... I am trying to use this if statement: IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")), the problem is I can not figure out how to tell it if the answer is greater than 0, put in the number and not J8*J25-J10*J25, can anyone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statements
=IF((J8*J25-J10*J25)<=0, 0, (J8*J25-J10*J25))
Syntax of IF: IF(test, result_when_test_TRUE, result_when_test_FALSE) Your formula could be simplified to =IF((J8-J10)*J25<=0, 0, (J8-J10)*J25) Also you could abandon IF and use (J8-J10)*J25)*((J8-J10)*J25)0) The Boolean expression (J8-J10)*J25)0 will evaluate to TRUE or FALSE which, when part of an arithmetic expression, are treated as 1 and 0, respectively. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "LAybar" wrote in message ... I am trying to use this if statement: IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")), the problem is I can not figure out how to tell it if the answer is greater than 0, put in the number and not J8*J25-J10*J25, can anyone help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using if statements
By putting text between ", the output willbe exactly as typed. remove the "
and you will get the result. so try : IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,J8*J25-J10*J25)) "LAybar" wrote: I am trying to use this if statement: IF((J8*J25-J10*J25)<=0,"0",IF(J8*J25-J10*J250,"J8*J25-J10*J25")), the problem is I can not figure out how to tell it if the answer is greater than 0, put in the number and not J8*J25-J10*J25, can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| "IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Hybrid Mode
