LinkBack URL
About LinkBacks
I'd like the formula in N2 to omit calculating values if the corresponding value in J3 or J4 is <-189.
=IF(AND(D2=1,E2="L",D3=2),IF(E3="W",K3,IF(D4=3,K4*3+K3,K3)),"")
I'd like the formula in N2 to omit calculating values if the corresponding value in J3 or J4 is <-189.
=IF(AND(D2=1,E2="L",D3=2),IF(E3="W",K3,IF(D4=3,K4*3+K3,K3)),"")
Last edited by quibilty; 10-14-2013 at 12:07 AM.
Try
=IF(OR(J3<-189,J4<-189),"",IF(AND(D2=1,E2="L",D3=2),IF(E3="W",K3,IF(D4=3,K4*3+K3,K3)),""))
Life's a spreadsheet, Excel!
Say thanks, Click *
Can you add the conditions into your and statement like this?
=IF(AND(D2=1,E2="L",D3=2,OR(J3<-189,J4<-189)),IF(E3="W",K3,IF(D4=3,K4*3+K3,K3)),"")
That's close. The formula I'm looking for would produce "100" at N5, and "100" at N24.
I think the one I posted is doing that, is it not doing something else you wanted?
First of all, I screwed up. I meant >-189, NOT <-189.
Secondly, this is what got me to the formula =IF(AND(D2=1,E2="L",D3=2),IF(E3="W",K3,IF(D4=3,K4*3+K3,K3)),"")
If: D2 = "1" & E2 = "L", check if D3 = "2". If D3 = "2" & E3 = "W" then show value of K3.
If: D2 = "1" & E2 = "L", check if D3 = "2". If D3 = "2" & E3 = "L", check if D4 = "3". If D4 doesn't = "3" then show value of K3.
If: D2 = "1" & E2 = "L", check if D3 = "2". If D3 = "2" & E3 = "L", check if D4 = "3". If D4 does = "3" then show value of K4 multiplied by 3 with K3 subtracted from that value ((K4*3)-K3).
Now look at N125. The desired value is "-115" because the formula should omit ((K4*3)-K3) because J127 is NOT >-189.
There isn't an example for it, but if the values for J127 & J126 were switched, the desired value of N125 be "-115". It would essentially be like omitting the first step of the above formula if J126 is <-189.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks