I'm trying to set up a budget where my last column shows what's left in my account in every cell from
F30. I want the cell to only show it's value if another cell on the same row has a value.
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 (
I have tried
=IF(B6="";"";"=DATA!AH6"), but it shows the text 'DATA!AH6', and not the value.