Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to enter a simple (so I thought) 3-If formula, but keep getting
errors: 2 IFs work: =IF(B1C1,B1-C1,IF(D1C1,D1-C1,"")) This formula works nicely for most of what I need, either the # or nothing. B C D result 1 1 B C D 1 1 B C D 1 First 2 samples above result in 1, the 3rd results in "", giving me the result I need. However, I also need a result of the D cell (2) if B=C=D. Trying to enter that 3rd IF isn't working. My unworking formula: =IF(B1C1,B1-C1,IF(B1=C1=D1,D1),IF(D1C1,D1-C1),"") The #'s will vary, but the below example is the result(2) I'd need in this situation: B C D 2 2 2 2 Any help for this problem would be greatly appreciated. Thanks much, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Help with what should be a simple formula | Excel Worksheet Functions | |||
Stupid Excel operating | Excel Discussion (Misc queries) | |||
Simple But Stumped | Excel Discussion (Misc queries) | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |