Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
27
Views
Topic starter
Hi-
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.
| A | B | C | D | E | F | G |
| Date | Description | Catergory | Amount | Responsibility | Paid | |
| Feb 7, 2020 | WRIGHT COUNTY | Personal | $500.00 | June | #VALUE! | |
| Feb 5, 2020 | AMZN Mktp US*WK2DH38Q3 | Shopping | $12.84 | Split |
Thanks in ADVANCE!
Posted : 08/02/2020 4:21 pm
Hi Jason,
Welcome to our forum. You're so close with your formula. It should be:
=IF(OR(E3="Jason",E3="June"),D3,D3/2)
Mynda
Posted : 08/02/2020 8:33 pm
