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

I'm trying to set up a budget where my last column shows what's left in my account in every cell from F6 to F30. I want the cell to only show it's value if another cell on the same row has a value.

Example:

If B6 is not empty, show the value of cell F6, leaving the rest of the cells in column F blank until they are summed up.The value in F6 is a formula from a different spreadsheet (=DATA!AH6).

I have tried =IF(B6="";"";"=DATA!AH6"), but it shows the text 'DATA!AH6', and not the value.

share|improve this question
    
Uhh @Tia, you might want to vote up and accept my answer if you feel it was helpful or it worked – YatharthROCK Aug 20 '12 at 8:58
    
Thank you. Can't get it to work in my sheet, but trying ; instead of , and with and without quotatinmarks. – Tia Aug 20 '12 at 9:54
    
Are you sure about using semicolons? I've only seen commas till now. – YatharthROCK Aug 20 '12 at 9:56
    
I'm using an european version of 2007, and not really able to find my way around it as I'm used to an english version of 2010. – Tia Aug 20 '12 at 10:10
    
Btw, how do I vote/accept? – Tia Aug 20 '12 at 10:10
up vote 0 down vote accepted

Add =DATA!AH6 w/o the quotes. Your formula should now look like

=IF(B6="","",=DATA!AH6)

This worked for me:

   A   B   ...
1 100 200
2  1  =IF(A2="1",SUM(A1:B1),"")
...
share|improve this answer

You must log in to answer this question.

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