• 0

Excel Over/Under help

Asked by tehmemories,

 Share

Question

Proficient

tehmemories

Posted
Posted

Hey guys, I'm doing a project and I need some help with Excel. I need a forumla to display and over/under dollar amount. The over/under dollar amount is $230. If the overall is under $230, I would like the dollar/decimal amount that it's short. And if it's short I need it to turn red. And green for the over. See attached.

post-66640-0-10647300-1347306517.jpg

Link to comment
https://www.neowin.net/forum/topic/1104591-excel-overunder-help/
Share on other sites

3 answers to this question

Recommended Posts

  • 0
Grand Master

+BudMan MVC

Posted
  • MVC
Posted

What do you not understand? If less than 230 red, if more than 230 green.

What version of excel are you using? Also your example makes no sense, there is nothing there showing anything close to 230. Looks like your trying to add up values of the bills/coins -- but doesn't make any sense since you have a value of 4?? And why wouldn't 100/50 have their own row same with $1/50 cents, etc..

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • Space Marine 2 gains a horde mode and DLSS 4 with new Siege update

      By LoneWolfSL · Posted

      Space Marine 2 gains a horde mode and DLSS 4 with new Siege update by Pulasthi Ariyasinghe Warhammer 40,000: Space Marine 2 just received its next major update. Dubbed the Siege update, it is finally bringing the long-promised horde mode for the third-person action game, as well as new tech for PC gamers. The Siege mode takes place on a fortified Imperial stronghold on Kadaku that is enduring endless attacks by Tyranids and Thousand Sons. There are three sections in total that players will defend in order before circling back to the original position, fighting away thousands of enemies in five waves before swapping locations. To give players a small break, there's a one-minute gap between each wave to resupply and purchase perks from the points they collect while in battle. Players can call in AI-controlled specialized soldiers, Space Marines, or even a Dreadnought to help out if the waves get a little too tough. To cap it all off, every fifth wave a boss encounter kicks off. There are 15 waves to go through in a single session, but parties can also kick off an endless mode at the end of these to see how far they can get. "Siege Mode expands on our PVE operations, emphasizing endless enemy waves that challenge even the strongest teams," says Focus Entertainment, describing the new mode. "When overwhelmed, players may call reinforcements for assistance. Engage in intense battles across three distinctive sectors, each requiring strategic adaptation. Side objectives emerge during combat, providing essential resources used to summon elite Space Marines or a formidable Dreadnought, drastically shifting battlefield dynamics. Over on PC, the studio has added two new options. One is RTAO (Ray-Traced Ambient Occlusion), though this is currently listed as an experimental feature. Next, Nvidia 5000 series graphics card owners can now enable DLSS 4 for better upscaling tech as well as multi-frame generation. The complete patch notes for Patch 8, which includes details on the balance changes, can be found here. The Warhammer 40,000: Space Marine 2 Siege update is now available on PC, Xbox Series X|S, and PlayStation 5.
    • After ditching XPS branding, Dell unveils Premium laptops starting at $1,649

      By CHUNWEI · Posted

      Dell Pro Max Premium Ultra
    • Microsoft updates Media Creation Tool with a newer Windows 11 release

      By TarasBuria · Posted

      Microsoft updates Media Creation Tool with a newer Windows 11 release by Taras Buria If you want to download a Windows 11 image or create an install media, the Media Creation Tool app is one of the best options—simple, fast, and, more importantly, official. While there are other useful alternatives, such as Rufus, Media Creation Tool remains the default choice for those who simply want a clean Windows 11 installation on a supported computer. Thanks to the latest MCT update, you will have to deal with fewer updates after installing Windows 11. Microsoft has quietly updated the Media Creation Tool app so that it downloads the latest Windows 11 release, version 24H2, with build number 26100.4349. This is the most recent public Windows 11 update (June 2025 Patch Tuesday), which eliminates the need to download large updates for your PC after installing the operating system. You can download Media Creation Tool from the official Windows 11 website. If you are familiar with it, this simple app can generate a Windows 11 image with the language you need or create a bootable USB media. Note that it only works on Windows, so Linux or macOS users have to download Windows images directly from the official website and then use apps that are available on their platforms. Another thing worth noting is Media Creation Tool is not the right choice if you want to install Windows 11 on an unsupported PC. In such a case, you can use MCT to download an ISO and then create a modified install media with apps like Rufus or Ventoy as described in our dedicated guide. If you want a more exotic Windows 11 Edition, try the Oofhours Media Tool, which allows you to select Windows 10 or 11, architecture (x64, x86, or ARM64), language, and edition. In addition to standard Home and Pro, the application can download non-mainstream SKUs, such as Enterprise, Education, or Professional for Workstations. Via: Deskmodder
    • After ditching XPS branding, Dell unveils Premium laptops starting at $1,649

      By LightEco · Posted

      Putting premium on your higher end laptops really makes it feel like your lower end laptops are worse.
    • Meta is now using every possible source to power its data centers

      By grik · Posted

      Funny enough just removed insta account and whatsapp is next. Less power needed now

  • Recent Achievements

    • Conversation Starter
      Kavin25 earned a badge
      Conversation Starter
    • One Month Later
      Leonard grant earned a badge
      One Month Later
    • Week One Done
      pcdoctorsnet earned a badge
      Week One Done
    • Rising Star
      Phillip0web went up a rank
      Rising Star
    • One Month Later
      Epaminombas earned a badge
      One Month Later

  • Popular Contributors

    1. 1
      +primortal
      538
    2. 2
      ATLien_0
      207
    3. 3
      +FloatingFatMan
      174
    4. 4
      Michael Scrip
      148
    5. 5
      snowy owl
      119
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!