Hi all, I'm trying to build a formula that isn't quite working it works for the first half, but if the first portion doesn't return a number it always says the second part is False. =IF(ISTEXT(J71),IF(AND(G76>0,J71=D71),I53,IF(ISTEXT(J71),IF(AND(J71<>D71),$I$53-K76-L76)))) So the part I highlighted blue seems to work, if there is text in J71 AND G76 is >0 AND J71=D71, J71 Will autofill as whatever is in cell I53. So to this point I'm achieving what I want, BUT if that is false, I want it to try Looking for text in J71 Again for text, and see if J71 AND D71 Are NOT the same, If they aren't I want it to just do a subtraction formula I53-K76-L76, If there is no text in cell J71 Then id just want it to return a 0 . Thanks for any help I can get!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Nested IF, Multiple Criteria, with ISTEXT
- Thread starter Lancer7
- Start date
Excel Facts
Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
So IF V71=P71 it would remain the S76 as in the formula IF(ISTEXT(V71),IF(V71=P71,IF(S76>0,U53,S76+U53),U53-W76-X76),0) If V71=J71 the S76 Would instead be M76 If it matched D71 THE S76 would be G76, Then if it finds no matches it would continue on to the next part of the formula
Upvote
0
