In an Excel spreadsheet, I want to do a formula where if D3 equals "Martin" then C3 is divided by 2 and this amount is entered into E3. Help?

2 Answers

Relevance
  • Lv 7
    1 year ago

    type into E3 an IF statement.

  • 1 year ago

    In cell E3, you need: =if(D3="Martin",C3/2,"")

    Note you didn't say what should be in E3 if "Martin" was not in D3 so I assumed it should be blank (which is the "" after the last comma.)

Still have questions? Get answers by asking now.