How to omit returning the rows for "false" values
I have a worksheet with multiple tabs. The first tab is the master sheet and columns A-G contain identifying data. In the second tab I have created a formula to return the value in column A of the master sheet if the value in column H is greater than Z.
The problem with the formula that I created is that it will also return all of the blank rows if column H is not greater than 0. How do I create a formula that will skip / not return the "false" rows?
41 Answer
=IF('Master Sheet'!H2>Z, 'Master Sheet'!A2, "")=IF(condition, value if true, value if false)
condition = if the value in column H is greater than Z
If True = If true, return the value in A2 (starting at A2, assuming you have a header row)
If False = If false, return a blank cell. I like to return a dash so I use "-", this way I know something was calculated.
This of course will result in having rows populated and blank, but a simple sort will bring your results to the top.
I hope this helps.
2
