you can use basic formulas in google
sheets
to create a formula select the cell
where you want to see your answer
at the top of your screen click on the
white bar next to the fx sign this is
where the formulas are stored for each
cell
you'll be able to write formulas here as
well as edit them
let's use a formula to add up how much
stock we have
first double-click where you want the
total and then type the equation in the
fx bar
always start a formula with an equal
sign followed by the formula instruction
type equals followed by sum in capital
letters
followed by open bracket followed by the
range
our range is from d5 to d13
as these are the numbers we want to
total so we'll type
d5 colon d13
followed by a closed bracket sign to
complete the equation
press enter if the formula has been
entered correctly
the total will immediately be shown in
the cell
if you've made a mistake perhaps you've
misspelled something
an error symbol will appear like this
then you should go back to your fx bar
and you can edit it until it's correct
you can learn how to create other
formulas by learning the google sheets
language