Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This one has me stumped: I have a spreadsheet that I need to know when I have a cell that is greater than another cell but show nothing when it doesn't.

Cell B9 is a sum of B2:B8 with these cells using information from other sheets in the workbook. Cell B13 is a number that I input. I am trying to get the sum of B9-B13 only when it is greater than B13, I need this cell to be blank when the sum is equal to or less than B13.

I know I am missing something simple but I cannot get the cell blank when it needs be. I am using Excel 2010, but it will also need to work in 2007 version.


share|improve this question

=IF(B9>B13,B9-B13,"") should do the job!

share|improve this answer

=IF(SUM(B9:B13)>B13,SUM(B9:B13)), perhaps?

Or, if by "the sum of" thou meanest "the result of", then =IF(B9-B13>B13,B9-B13) should do it. If those don't work, try adding a ,"" before the closing bracket in whichever expression thou usest, to explicitly specify a blank value if the condition for the IF is false.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .