Not clear what you want to achieve.
Do you want H3 to be another OR variable or do you want it to be if H3 is blank AND OR(B3<>"BTC",J3>0.05).
If you could spell out the whole logic it would help.
Ed
_____________________________
Always learning, but never enough!
_____________________________
I think this is the entirety of the formula conditions and logic in plain english:
If column D is blank, then do nothing; OR if column B = "BTC" and column H is blank and column L is equal to or less than 0.05, then column O = 0; OR if column H is blank and column J is greater than 0.05, then multiply column D times -1.25; OR take column D times 2 multiplied again by -1.25
I think that is the entirety of what I need it to do. Hopefully I haven't left out anything.
As always, many thanks!
something like
=IF(D3="","",IF(AND(B3="BTC",H3="",L3<=0.05),0,IF(AND(H3="",J3>=0.05),D3*-1.25,D3*2*-1.25)))
Ed
_____________________________
Always learning, but never enough!
_____________________________
Beautiful!! Your formula was actually about 99.9% correct, but I found the error which I'm sure was just an oversight and it works perfectly. Hopefully now that I've said that I won't find another error, but I think we're good to go. Thank you Ed!
- John
No problem - thanks for the feedback.
Ed
_____________________________
Always learning, but never enough!
_____________________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks