Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Freddy Finger
Freddy Finger asked in Computers & InternetSoftware · 6 years ago

Excel 2013 Calculation Question?

If any Excel spreadsheet master might be willing to share their knowledge, I would greatly appreciate it.

I'm trying to figure out how to set up a calculation in a cell that is conditional based on what is in another cell.

Example:

I want cell A to multiply cell B by 2 only if cell C has an 'x' in it. If there is not an 'x' in cell C then cell A should show as zero. What formula/function might that be?

Thanks in advance for your reply.

2 Answers

Relevance
  • BT_Bot
    Lv 5
    6 years ago
    Favorite Answer

    Supposing the cells in your question: A, B, C are cells A1, A2, A3 respectively:

    Use a comparison to check if C is "x" which will give a true/false result (1/0 in a math formula), so your formula for cell A (A1) could be:

    = (A3 = "x") * 2 * A2

  • IXL@XL
    Lv 7
    6 years ago

    A1 =IF(C1<>"x",B1*2,0)

Still have questions? Get your answers by asking now.