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
C.G. Triggs
C.G. Triggs asked in Computers & InternetProgramming & Design · 1 decade ago

Excel, solve multiple simple subtraction?

I'm trying to get excel to solve b1-b2, but I'm trying to get it also to do c1-c2,d1-d2 and so on.

Also, if the answer is 1, it should say "A", another number, 3 should give "B" and so on.

1 Answer

Relevance
  • Anonymous
    1 decade ago

    this will work if those are the only two letters A and B, but the more you add, the more 'nested' your if statement becomes...

    =IF(B1-B2=1,"A","B")

    then copy this formula down

Still have questions? Get your answers by asking now.