Subtract 2 Cells

dgarnas

I am feeling completely inadequate, lol! Just trying to simply subtract one cell from another. I have tried various ways. This is one way:

=[FY26 Member Fee]@row - [[FY 25 Member Fee]@row]

Please help! Thank you

BrunoC

You have extra brackets...it should look like this

=[FY26 Member Fee]@row - [FY 25 Member Fee]@row

dgarnas

I tried that to begin with and just keep getting #INVALID OPERATION. Any other ideas?

ECarlson_PCG

@dgarnas Is the column name of the second reference "FY 25 Member Fee" while the first column is "FY26 Member Fee"?
In comparing, looks like there is an extra space between FY and 25 ^

=[FY26 Member Fee]@row - [FY25 Member Fee]@row

You're correct in that it should just be a "-" to subtract!

dgarnas

I figured out that the problem arose in the how I had my cells formatted that I was trying to subtract. The problem has been resolved. Thanks!