[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to target cells based on negative and positive numbers.

Posted on 2009-02-21
5
Medium Priority
?
321 Views
Last Modified: 2013-12-12
Hello,
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.
0
Comment
Question by:mobileitsupport
  • 3
  • 2
5 Comments
 

Author Comment

by:mobileitsupport
ID: 23701642
I just added the Excel file.
0
 
LVL 50

Expert Comment

by:Dave Brett
ID: 23701767
... no you didnt :)
0
 

Author Comment

by:mobileitsupport
ID: 23701920
Okay, it should be attached now.
Poker-Buy-Schedule-2003.xls
0
 
LVL 50

Accepted Solution

by:
Dave Brett earned 2000 total points
ID: 23701976
in I6
=IF(H6+F6>0,H6+F6,"")
in H6
=IF(H6+F6<0,H6+F6,"")
see attached
Cheers
Dave

Poker-Buy-Schedule-2003-1----djb.xls
0
 
LVL 50

Expert Comment

by:Dave Brett
ID: 23701987
for H6 read J6
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While Plesk offers many potential benefits to website administrators, including compatibility with Windows Server and other leading technologies, the company has also been working to differentiate it from other control panels for content management…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question