Forum Discussion
Array Formulas with IF statements
Hi, I'm fairly new to using Array Formulas, and am having some trouble getting a more complex one (for me) to work in a spreadsheet. I have the following formula that I want to be auto-applied to an...
I guess you are working with Google Sheets, correct?
Yes - from what I've read the functions seem to work similarly between Excel and Google Sheets (other than the way the equation starts).
It is similar but it's not the same, the devil is in the detail. In addition and as another example, reference you use as C2:C doesn't work in Excel at all.
Okay - thank you. It's obvious I'm not savvy at either!
