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
bluemazdatruck1995
Lv 5
bluemazdatruck1995 asked in Computers & InternetProgramming & Design · 6 years ago

I need an excel formula that will blank out a cell if the sum of several cells is zero.?

I have tried to use:

=if(f9:t9=0,"",f9:t9)

but it says there is an error in the "f9:t9=0"

2 Answers

Relevance
  • expletive_xom
    Lv 7
    6 years ago
    Favorite Answer

    put your f9:t9 inside the SUM() function

    =if(SUM(f9:t9)=0,"",SUM(f9:t9))

    it should just work with a copy&paste.

  • Iggy Rocko
    Lv 7
    6 years ago

    f9:t9 should be sum(f9:t9)

Still have questions? Get your answers by asking now.