How to target cells based on negative and positive numbers.
Posted on 2009-02-21
I'm trying to target a specific cell if there's an amount due and another cell if there's an amount owed. For example, if the sum of total buy ins and chips in hand are negative, then I want that number to populate in cell I6. Conversely, if the number if positive, I want that number to appear in cell J6. I attached the file so that you can see what I'm talking about. I changed the extension to xl1 (from xlsx) so that I could post the file. Thanks for your help.