paste the formula and find these is something wrong

dear sir/madam

i am trying to paste the formula as file attached from cell o2 and p2
to o3 p3 and o4 p4 , the expect result of cell o3, cell p3 should be 510 and 4
04 ,p4 should be 350 and 3

but after paste the result is 350 5. it is not our expected? what's wrong

Works okay for me when I copy the formulae down.

Pete

pls try this file and to see what is wrong. tks

Turn on automatic calculation

File - Options - Formula - Automatic

its working

Again, no problems.

You might have your calculation options set to manual (on the Formulas tab) - ensure it is set to Automatic.

Hope this helps.

Pete

yes when i save, the function work. it is ok .tks