Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now 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
seattlecutiepie
Lv 5
seattlecutiepie asked in Computers & InternetSoftware · 1 decade ago

Excel formula question...HELP!?

I have a cell that has a formula in it and if the answer is less than zero, I'd like it to display a zero instead of the negative answer. Is there a way to build that into the formula?

Thanks in advance

PS ~ The current formula is =sum(e28:e33)-40

4 Answers

Relevance
  • S B
    1 decade ago
    Favorite Answer

    Copy and paste this: just pretend there is no "enter"

    =IF((SUM(E28:E33)-40)<0,0,(SUM(E28:E

    33)-40))

    Hope this helps

  • Sarah M
    Lv 5
    1 decade ago

    = MAX( yourformula, 0 )

    = MAX(SUM(E28:E33)-40, 0)

  • paducahbill
    Lv 6
    1 decade ago

    At the block where you want the answer

    Press Insert, select Function, Select If, then put in your equations and answers here.

  • Anonymous
    1 decade ago

    If you have an Excel question then you should go to Mr. Excel.com. They have a great bunch of people that know Excel inside and out.

    Source(s): http://www.mrexcel.com/
Still have questions? Get your answers by asking now.