February 8, 2020
I've struggled with this for a bit now hoping someone with more expertise can help...
Here is my failed attempt: =if(OR(E3="Jason","June"),D3,D3/2)
What I need is if E is either Jason Or June but the amount that is in D into column G.
If something other than Jason or June divide D by 2.
|Feb 7, 2020||WRIGHT COUNTY||Personal||$500.00||June||#VALUE!|
|Feb 5, 2020||AMZN Mktp US*WK2DH38Q3||Shopping||$12.84||Split|
Thanks in ADVANCE!