Please help me find the flaw in this formula: =IFERROR((A2:A4)-(A5:A7)/A1,"")
Intention is to add A2:A4, then subtract the sum of A5:A7 and divide by A1 to return a percentage or a blank. This is giving me a #spill error.
Thanks in advance!
Intention is to add A2:A4, then subtract the sum of A5:A7 and divide by A1 to return a percentage or a blank. This is giving me a #spill error.
Thanks in advance!