In Excel, I am using an IF function and using the OFFSET function to assign a value in the [value_if_true] and using a 0 for the [value_if_false]. The true OFFSET function was occasionally returning #ref! and #value! errors because it was referencing cells off the worksheet, so I re-coded it in a way that the result would be FALSE [value_if_false] if the cell referenced in the [value_if_true] offset function would be off the sheet.
It seems like Excel doesn't just ignore the [value_if_true] offset function if the value is FALSE. It is still giving me the same errors.
In an IF function, is there a way to make Excel ignore the TRUE value's function and only post the FALSE value? I know my error is coming from the TRUE value's function because when I change only the TRUE value the error goes away.
This is my formula: