Formula output not as expected-help needed

Copper Contributor


I am having trouble with my formula as it is not generating accurate results for any of the cells it is applied to. Moreover, the formula shows the identical outcome for every cell despite using distinct cell references in each case.


The formula is the following:




I am able to get the correct output when I manually compute, but I am uncertain about the mistake in my computation.


Any help would be appreciated.


Screenshot 2023-06-07 at 12.52.30 PM.png

3 Replies
best response confirmed by epyxx (Copper Contributor)


Are you in Automatic mode?


I checked and I was in manual mode. I changed to Automatic mode and it solved the problem.
I'm an amateur Excel user but have never run into a Formula problem like this.

Thanks so much for your quick reply and solution. Very grateful.

@epyxx , you are welcome, glad to help