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
Candice
Candice asked in Science & MathematicsMathematics · 1 decade ago

Excel Formula question?

Hi and please advise what formula in Excel is this?

=IF(P34=0,0,IF(O34=0,1,IF(M34=0,-1,ROUND(P34/O34,2))))

Thank you

Candice

2 Answers

Relevance
  • ans.wer
    Lv 5
    1 decade ago
    Favorite Answer

    It is the if function.

    It says. if cell P34 is 0, then input 0 into the current cell (current cell as in the cell the formula is entered into).

    However, if P34 is not 0, then check if cell M34 = 0. If that is true, input -1 into the current cell.

    If M34 is not 0 than Round(..... whatever is in the brackets.

    Hope this helps.

  • Anonymous
    1 decade ago

    looks like a number line... ?

Still have questions? Get your answers by asking now.