Apple Numbers help

3
Posted 25th Dec 2019
Hello guys

I wonder if anyone can help me with apple numbers similar to excel

I want the “sale” cells value to subtract the “cost” cells and provide the answer in the “profit” cells.

I’m unsure how to do this on apple numbers


3374247-Pawnz.jpg
Community Updates
Ask

Groups

3 Comments
Very similar to excel.
Click in profit cell and start typing =

(As in, type the equals symbol)

Should look something like:
=sum(a2-a3)
wixster26/12/2019 00:46

Very similar to excel.Click in profit cell and start typing =(As in, type …Very similar to excel.Click in profit cell and start typing =(As in, type the equals symbol)Should look something like:=sum(a2-a3)


Thanks for this. Is their anyway I can make it automatically do it for the whole column. Or do I have to put the formula in for each row.
Click the cell with the formula you just wrote and click on the little yellow dot that should be near the bottom of the cell, drag that all the way down.
Post a comment
Avatar
@
    Text

    Discussions

    Top Merchants