Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
I'm trying to put a formula in the cell that runs a formula, and if hte
result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
=IF(+J2-I2<0,"0","=SUM(J2-I2)")
The "=SUM(J2-I2)" is text. Try: =IF(J2-I2<0,0,SUM(J2-I2)) Tyro "kleivakat" wrote in message ... I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Worked like a charm. Thanks very much.
"Tyro" wrote: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The "=SUM(J2-I2)" is text. Try: =IF(J2-I2<0,0,SUM(J2-I2)) Tyro "kleivakat" wrote in message ... I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
I'd use:
=IF(J2<I2,0,J2-I2) or even: =MAX(0,J2-I2) kleivakat wrote: I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Could you please help me with a slightly different version of this issue? I have
a dollar value in cell J133. I also have dollar values in cells J131 and J134. In cell J136, I want to insert the following: If J134 is less than the value in J131, then enter a "NO" in cell J136 but if J134 is = J131, then enter the computed dollar value in cell J136. Thanks! Bill On Tue, 26 Feb 2008 11:36:29 -0600, Dave Peterson wrote: I'd use: =IF(J2<I2,0,J2-I2) or even: =MAX(0,J2-I2) kleivakat wrote: I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Not enough info to provide a formla. You say to return the computed dollar
value. What computation? e.g =IF(J134<J131,"NO",Enter what computed dollar value?) if the computed dollar value is the difference between J134 and J136 =IF(J134<J131,"NO",J134-J131) Tyro "Bill Helbron" wrote in message ... Could you please help me with a slightly different version of this issue? I have a dollar value in cell J133. I also have dollar values in cells J131 and J134. In cell J136, I want to insert the following: If J134 is less than the value in J131, then enter a "NO" in cell J136 but if J134 is = J131, then enter the computed dollar value in cell J136. Thanks! Bill On Tue, 26 Feb 2008 11:36:29 -0600, Dave Peterson wrote: I'd use: =IF(J2<I2,0,J2-I2) or even: =MAX(0,J2-I2) kleivakat wrote: I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
I see my error now. Thanks!
Bill On Tue, 26 Feb 2008 13:44:53 -0800, "Tyro" wrote: Not enough info to provide a formla. You say to return the computed dollar value. What computation? e.g =IF(J134<J131,"NO",Enter what computed dollar value?) if the computed dollar value is the difference between J134 and J136 =IF(J134<J131,"NO",J134-J131) Tyro "Bill Helbron" wrote in message .. . Could you please help me with a slightly different version of this issue? I have a dollar value in cell J133. I also have dollar values in cells J131 and J134. In cell J136, I want to insert the following: If J134 is less than the value in J131, then enter a "NO" in cell J136 but if J134 is = J131, then enter the computed dollar value in cell J136. Thanks! Bill On Tue, 26 Feb 2008 11:36:29 -0600, Dave Peterson wrote: I'd use: =IF(J2<I2,0,J2-I2) or even: =MAX(0,J2-I2) kleivakat wrote: I'm trying to put a formula in the cell that runs a formula, and if hte result is less than zero, enter zero; if the result is not less than zero, enter the result. Here's what I have so far: =IF(+J2-I2<0,"0","=SUM(J2-I2)") The first part works, i.e., if the number is less than zero a zero appears, but the second part doesn't report the result if the number is greater than zero. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |