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!
This is for what forums for. However, even if we try to help here we need to play a bit with formulas in Excel, and when you apply these formulas to Google Sheets most probably they won't work. Try to follow Ingeborg' advice and ask your question Google Sheets community.