iWork
Q: Working with the IF command and checklists
Hello,
I have a question that I'm struggling with regarding the If command.
Basically, I am setting up a spreadsheet for my taxes, and I have certain recurring expenses that I can only put a certain percentage of the total cost through. I currently have it set up as a drop down menu with several options so I would like a collum that says "If d23 is 'internet' or 'phone bill' then f23*0.50 if d23 is 'fuel' then f23*0.25 if d23 is 'food' then f23 = d23" but I cannot work out the formula for the life of me!
I hope that makes sense!
MacBook Pro (Retina, 15-inch, Early 2013), OS X El Capitan (10.11.6)
Posted on Sep 15, 2016 11:20 AM
