+ Reply to Thread
Results 1 to 2 of 2

Message box when a formula becomes negative

  1. #1
    Registered User
    Join Date
    03-31-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    0

    Message box when a formula becomes negative

    Hey,

    I hope someone can help me!

    I want a error message (or even better a prevention mechanism) to warn me when a cell becomes negative.

    I have four worksheets, "Stock" "Purchases" "Sales" and "Stock Check"
    In "Stock Check", ("Stock" Cell E8 + "Purchases" Cell G8) - "Sales" Cell G8 = "Stock Check" Cell I8


    "Stock Check" Cell I8 should ALWAYS be greater or equal to 0!

    I want an error message to pop up if it ever falls below zero, (or better still not allow Cells in Stock, Purchases and Sales to be changed if it causes "Stock Check" Cell I8 to become negative)

    I hope someone can help me, it would be really appreciated!

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,150
    Hello sachinshah94,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] SUMIF positive and negative numbers - take double a negative number?
    By Zordrail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 08:34 AM
  2. Replies: 1
    Last Post: 04-26-2012, 12:48 AM
  3. Replies: 5
    Last Post: 05-12-2009, 04:47 PM
  4. Replies: 1
    Last Post: 11-20-2008, 01:52 AM
  5. [SOLVED] Excel Formula Negative/Negative =+%
    By BigDon in forum Excel General
    Replies: 1
    Last Post: 05-31-2005, 09:05 PM

Tags for this Thread

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