Results 1 to 3 of 3

Thread: Help With Formula

  1. #1

    Help With Formula

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi There

    Does anyone know how I would create a formula for the below:

    In column H (budget>5%) create a formula using an appropriate function or functions to compare column G (% probable outlook) with B9 (percentage of year completed) and automatically display the words "over Budget" when ever there is a greater than +5% difference. The cell should display as blank if the value is not met. Use the following items in the formula

    Over budget
    Percentage of the year Completed

    Thanks for looking


  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Hi and welcome
    please do not hijack existing threads but create one of your own.
    I did it for you this time
    Thank you Ken for this secure forum.

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Looking at the text in bold in msg#1, it looks very much like this is a test question/assignment.

Posting Permissions

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