Hi everybody
Hoping you can help where my brain has failed!
I’m looking for a formula I can use that lets me count the number of edges in a grid of variable size.
So ideally, I’d like to have two inputs (example in A1 and A2 where I could put a 2 in A1 and a 2 in the A2 for a 2x2 grid) and the output would then give me the number of edges of a grid in this formation. In this case, 12.
But then I could input in a 3 and a 4, and the output would amend to this new size, and give me an edge count of 31.
All help appreciated! Not even sure if this is doable, but hopefully it is!
Thanks in advance!
Hoping you can help where my brain has failed!
I’m looking for a formula I can use that lets me count the number of edges in a grid of variable size.
So ideally, I’d like to have two inputs (example in A1 and A2 where I could put a 2 in A1 and a 2 in the A2 for a 2x2 grid) and the output would then give me the number of edges of a grid in this formation. In this case, 12.
But then I could input in a 3 and a 4, and the output would amend to this new size, and give me an edge count of 31.
All help appreciated! Not even sure if this is doable, but hopefully it is!
Thanks in advance!