+ Reply to Thread
Results 1 to 2 of 2

formula

Hybrid View

  1. #1
    Registered User
    Join Date
    09-06-2008
    Location
    Knotttingley
    Posts
    2

    formula

    Is it possible to create a formula that shows a 0 when the total is a minus after a calculation ?
    Let me explain .
    Cells a1 to a12 is Jan to Dec
    Cells c1 to c12 is monthly use
    Formula in say cell c2 is ( +a2-a1) , cell c3 is ( +a3-a2 )and so on across to c12 which will then give a negative value in the following c cell ( cell c3 ( +a3-a2 ) ) then shows a negative value in cell c4 as the months go by . so the formula that I am after is say where March figure ( a3 ) is inserted giving a monthly use in c3 , and there is no entry in April ( a4 ) the negative figure is shown in cell c4 . I would like this c4 cell to show 0 .
    May I thank you in anticipation of your assistance

    Franky

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Franky,

    Please read the forum rules below then amend your title to be more descriptive

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. A formula template
    By ajaysehgal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2013, 06:12 AM
  3. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. use cell content as cell address in formula
    By nnsc in forum Excel General
    Replies: 4
    Last Post: 11-05-2006, 03:12 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1