How EDIT a formula?

asked 2019-10-28 12:12:49 +0200

abi gravatar image

HP Pentium, win 10,LibO 6.3; a1=1,[num frmt] , b1=18:00,[time frmt], … repeated 6X. How SELECT alternate cells[only time frmt] - for AVERAGE Formula ?

edit retag flag offensive close merge delete


Not sure I understand what you want to do, but to edit the formula used in any cell first left-click on the cell. Then move the cursor to the Formula bar near the top of the window and click on the text of the formula appearing there. You can change the range of the data, the function, anything you like. Be sure to hit Enter when you are done, in order to exit edit mode.

ve3oat gravatar imageve3oat ( 2019-10-28 14:53:40 +0200 )edit

You'll only understand 0.01% of abi's questions anyway and s/he never bothers to write comprehensible questions even after having been asked for a dozen times. Just ignore if you don't get it at the first grasp.

erAck gravatar imageerAck ( 2019-10-28 19:00:33 +0200 )edit

Thanks, @erAck. Am wiser now.

ve3oat gravatar imageve3oat ( 2019-10-28 22:58:18 +0200 )edit

Simple answer : =AVERAGE(B1,B3,B5) or =AVERAGE(B2,B4,B6)

Probably not what you want.

ve3oat gravatar imageve3oat ( 2019-10-28 23:01:14 +0200 )edit