Formula output not as expected-help needed

[epyxx]

Hello,

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:

=(E4*(L4*M4))+(F4*(100%-(L4*M4)))

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.

[#2 · Accepted solution]

@epyxx 

Are you in Automatic mode?

[#3]

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.

[#4]

@epyxx , you are welcome, glad to help