=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