Forum Discussion
Inconsistent excel formula
In the file attached below, I am facing an error of inconsistent formula for column J. I tried to fix it but I am not able to. Any help would be appreciated. TIA
Yea_So I am attaching the file I tried to solve. But it still shows the same.
I wouldn't worry about that. I guess the warning is because the formula refers to the following row as well as to the row itself. But that is intentional.
You can shorten the formula to
=(1+H4)^B4/(1+H3)^B3-1