Nested if question
 

In the cell where the formula resides, I get a FALSE result. My
intention is that I get a message that says "No Deprec. this yr". My
formula is as follows:

=IF(B36<$D$23,IF(E36<D36,(1/C36*D36),"No Dep. This yr"))

If anyone can tell me where I am going wrong, please let me know.
Thanks everyone!


--
dakotasteve
------------------------------------------------------------------------
dakotasteve's Profile: http://www.excelforum.com/member.php...fo&userid=5446
View this thread: http://www.excelforum.com/showthread...hreadid=468001

Without seeing your data and fully understanding what you are comparing,
I think this may meet your needs:

=IF(AND(B36<$D$23,E36<D36),(1/C36*D36),"No Dep. This yr")

as your formula looks first at B36<D23 and if true then looks at
E36<D36. If true then do the math. Therefore if either are false, "No
Dep...." should be returned.

Is this what you are trying to accomplish?

Alternately, you could simply add a second 'value_if_false' parameter,
as such:

=IF(B36<$D$23,IF(E36<D36,(1/C36*D36),"No Dep. This yr"),"No Dep. This
yr")

as you have two IF statements, you need two 'value_if_false' values,
else the default "FALSE" is returned.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468001

=IF(B36<$D$23,IF(E36<D36,(1/C36*D36),"No Dep. This yr"),"this is B36=d23")

Or maybe if you want the same message:

=if(and(b36<$d$23,E36<d36),1/c36*d36,"no dep. this yr")


dakotasteve wrote:

In the cell where the formula resides, I get a FALSE result. My
intention is that I get a message that says "No Deprec. this yr". My
formula is as follows:

=IF(B36<$D$23,IF(E36<D36,(1/C36*D36),"No Dep. This yr"))

If anyone can tell me where I am going wrong, please let me know.
Thanks everyone!

--
dakotasteve
------------------------------------------------------------------------
dakotasteve's Profile: http://www.excelforum.com/member.php...fo&userid=5446
View this thread: http://www.excelforum.com/showthread...hreadid=468001

--

Dave Peterson

dakotasteve,

The Reason that you were getting FALSE as a return from your formula was
that you have not provided an option for when the 1st test was false. If
the 1st test:

=IF(B36<$D$23

is not true then XL will skip the "do is test true" part of the formula
which in your case is the ENTIRE next IF statement:

IF(E36<D36,(1/C36*D36),"No Dep. This yr")

So being as there is no other option, the formula returns FALSE


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"dakotasteve"
wrote in message
...

In the cell where the formula resides, I get a FALSE result. My
intention is that I get a message that says "No Deprec. this yr". My
formula is as follows:

=IF(B36<$D$23,IF(E36<D36,(1/C36*D36),"No Dep. This yr"))

If anyone can tell me where I am going wrong, please let me know.
Thanks everyone!


--
dakotasteve
------------------------------------------------------------------------
dakotasteve's Profile:
http://www.excelforum.com/member.php...fo&userid=5446
View this thread: http://www.excelforum.com/showthread...hreadid=468001