I'm using if/and statements.
With the attached spreadsheet, if Cell E6 AND column D6 meet both criteria I set, I want the return to be the result of a calculation, and left blank if neither of the criteria are met.
This works fine for row 1 in my sheet; The year is 2019 (I have asked it to look for 2021), and although there is something in column D, a blank is returned. This is what I'm after.
However for row 2, applying the same if/and formula, when both criteria are met - i.e. the year is 2021 and there is also something in column D, it still returns a blank.
In row 3, I have switched the "value if True" and "value if False" and the calculation works.
My simple understanding of IF/AND is it both criteria are met I want it to do this (value if true), but if they're not both met (value if false), then I want it to do that. Have I got this wrong? Why can't I get the if/and to work?
N.B My attachment is a very simplified version of my actual working sheet. To simplify the calculation require imports minus exports = balance.
Bookmarks