| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
| IF NESTED Question | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Threaded Mode
