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(E36D36,(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,E36D36),(1/C36*D36),"No Dep. This yr")

as your formula looks first at B36D23 and if true then looks at
E36D36. 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(E36D36,(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(E36D36,(1/C36*D36),"No Dep. This yr"),"this is B36=d23")

Or maybe if you want the same message:

=if(and(b36$d$23,E36d36),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(E36D36,(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(E36D36,(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(E36D36,(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