Jaackable

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

Close

Q: Working with the IF command and checklists

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 15, 2016 12:03 PM in response to Jaackable
    Level 6 (19,282 points)
    iWork
    Sep 15, 2016 12:03 PM in response to Jaackable

    This might help you.

     

    Screen Shot 2016-09-15 at 1.57.54 PM.png

     

    create a second table called "PercentLookup" (as shown on the right).  The first row is a header row.  Enter the category and percents as show... add others iff you like

     

    Then in the table on the left use the following formula

    D2=C2×VLOOKUP(B2,PercentLookup::A:B, 2, 0)

     

    this is shorthand for… select cell D2, then type (or copy and paste from here) the formula:

    =C2×VLOOKUP(B2,PercentLookup::A:B, 2, 0)

     

    select cell D2, copy

    select cells D2 thru the end of column D, paste