Posted to microsoft.public.excel.worksheet.functions
|
|
Problem with IF Statement
Why -3?
Why -8.52?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"M Peddle" wrote in message
...
I am still not getting the outcome that I would like. Sorry, I am probably
expalining this all worng.
Maybe this will help explain what I am trying to do:
C5 = 0
D5 = 11
I5 = 36.55
J5 = 11
I would like my answer to be 0
C6 = 6.82
D6 = 4.18
I6 = 36.55
J6 = 14
I would like my answer to be -3
C7= 2.48
D7 = 8.52
I6 = 36.55
J6 = 31
I would like me answer to be -8.52
It would be great if we could make it a negative number as well, if not no
big deal.
Thanks for your help!
"Bob Phillips" wrote:
=IF(D1=0,0,IF(AND(J111,J1<=I1),J1-D1,"FalseCondition"))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"M Peddle" wrote in message
...
Sorry, I left out part of my criteria.
If D=0, then enter 0 and don't look at the rest of the formula but if D
is
greater than 0 and J is more than 11, but not more than I, I need to
know
what is J minus D
Thanks for your help
"PCLIVE" wrote:
Maybe this:
=IF(AND(J111,J1<=I1),J1-D1,"FalseCondition")
You'll need to specify the FalseCondition. If you want it to remain
blank,
then:
=IF(AND(J111,J1<=I1),J1-D1,"")
HTH,
Paul
--
"M Peddle" <M wrote in message
...
I am not even sure if this is possible or not.
If J is more than 11, but not more than I, I need to know what is J
minus
D
|