google spreadsheet multiple range of cells in if statement
Posted on 2015-02-05
Hi I'm doing an expense spreadsheet in google spreadsheet, and I am trying to do a if statement over a range of cells, from another sheet in the project.
I have one tab which is called Expenses 2015 and the other tab called Entries. But when I try to do an if statement I get a formula parse error.
=IF(AND(Entries!A3:Entries!A1000 >= DATE(2015;1;1); Entries!A3 < DATE(2015;2;1)); if(Entries!C3 = "NET"; if(Entries!D3 > 0; Entries!D3; Entries!E3); 0); 0)
I get Formula Parse Error.