Results 1 to 11 of 11

Formula to get 100% or -100% increase or decrease respectively when divided by zero

Threaded View

  1. 01-11-2018, 05:18 AM #1
    archimaitreya
    archimaitreya is offline
    Registered User
    Join Date
    02-23-2016
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    65

    Formula to get 100% or -100% increase or decrease respectively when divided by zero

    Hi,

    I need help on creating a formula to calculate growth or degrowth when being divided by the zero. Usually dividing by zero gives error as mathematically it isnt possible. However, this gives and incorrect picture when i want to check if there has been a growth/degrowth.

    Enclosed excel has the data and the expectations. Unable to put a table here. However, the objectives are:

    To have 0% Growth in cell E3
    To have 100% growth in Cell F3, G3 and E4
    To have -100% growth in cell G4

    Please help!!!!
    Attached Files Attached Files
    Last edited by archimaitreya; 01-11-2018 at 05:27 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. $20 increase/decrease in price, 50,000 decrease/increase in the number of units sold
    By Michaael01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2012, 01:01 AM
  2. Increase/Decrease
    By mifzal.mufthi in forum Excel General
    Replies: 4
    Last Post: 08-10-2012, 04:19 AM
  3. formula to get an increase or decrease %
    By legepe in forum Excel General
    Replies: 2
    Last Post: 05-04-2010, 02:01 PM
  4. % Increase and decrease.
    By DODGE in forum Excel General
    Replies: 5
    Last Post: 03-02-2010, 05:01 PM
  5. % of Increase - Decrease - Formula
    By Desert Piranha in forum Excel General
    Replies: 12
    Last Post: 01-24-2007, 07:02 PM
  6. [SOLVED] increase/decrease decimal
    By cbfinancial in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2006, 05:50 PM
  7. % of increase or decrease
    By Neil R in forum Excel General
    Replies: 9
    Last Post: 11-26-2005, 11:15 PM
  8. [SOLVED] How do I set a cell that can increase but never decrease?
    By Rich in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1