F
F
fStrange2016-02-10 13:28:53
Google Sheets
fStrange, 2016-02-10 13:28:53

How to automatically calculate column cell value?

The simplest case. There is a table. Data is entered into column B through forms.
In the adjacent column in cell C I want to see the percentage of the corresponding cell in column B .
I know how to enter this value for already existing cells. But I don’t know how to make it automatically considered for new values.
Those. Let's say I entered a new value through the form. It was displayed in B5, I need the value calculated from B5 to appear in cell C5.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
DevMan, 2016-02-10
@fStrange

creating the required formula in cell C1 and dragging it down doesn't it help?

more or less like this
51123787fd47402cb22a8768254607f8.gif

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question