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
Thanks!! So that works perfect but now that I have it done and am testing it out Iv realized I need one more outcome added To the blue part, if G76 happened to be LESS than <0, Id want it to add G67+I53, =IF(ISTEXT(J71),IF(AND(G76>0,J71=D71),I53,IF(J71<>D71,$I$53-K76-L76,0)),0)
Upvote
0
To complicate it hopefully one last time on you here, If I have IF(ISTEXT(V71),IF(V71=P71,IF(S76>0,U53,S76+U53),U53-W76-X76),0) from the same sheet using the same formula you built Id like to Have V71 look for a match in P71 but this time if it doesn't match Id like to have it look at J71 for a match and if it doesn't match look at D71 for a match. Then if it finds a match on any of those the formula structure would stay the same but S76 would have to change in the formula to correspond to how many cells to the left we had to move to find a match
| Glyphosate | Chemical name | Acres on Farm | Booked | Needed | Glyphosate | Chemical name | Acres on Farm | Booked | Needed | Glyphosate | Chemical name | Acres on Farm | Booked | Needed | Glyphosate | Chemical name | Acres on Farm | Booked | Needed | |||
| 2023 Plan | Glyphosate | 2023 Plan | Glyphosate | 2023 Plan | Glyphosate | 2023 Plan | Glyphosate | |||||||||||||||
| Carry Over | Glyphosate | Carry Over | Glyphosate | Carry Over | Glyphosate | Carry Over | Glyphosate | |||||||||||||||
1649.175412 | 3542.824588 | 1649.175412 | 5658 | 1649.175412 | 0 | 1649.175 | 0 |
Upvote
0
Sorry, Definitely not trying to waste your time I really appreciate the help. I'm just trying to build this spreadsheet as I can make formulas work and I'm not a excel expert by any means So I'm just trying to visualize the end goal and iv realized with this one a couple changes I needed to make now. But yes I do think this is the last one
Upvote
0
