Skip to main content
Home

Main navigation

  • Apps
  • Forum
  • Blog
    • Podcast
    • Guides
    • Hardware & Accessory Reviews
    • Bug Tracker
    • Developer Resources
  • Log in

Breadcrumb

  1. Home
  2. Forums
  3. macOS and Mac Apps

Using formulas in Numbers for Mac.

By LupeDrums82, 4 July, 2021

Forum
macOS and Mac Apps

Hi everybody,

I've been trying to create a budget spreadsheet on numbers for Mac and I keep running in to a issue with inputing a formula in my spreadsheet. Does anyone know the correct way to use formulas in Numbers? I have already created my budget spreadsheet just need the formula to complete it. I apreciate the tips for this issue I'm having.

Options

  • Log in or register to post comments

Comments

In ios I know.

By Unregistered User (not verified)

1 year 8 months ago

Hi!
activate any cell for editing.
For example, A3.
Then type the following:
A1+A2

Supposing the data are in A1 and A2 cells.
Type any formula you want.
Or choose the suitable one from fast/quick formula menu.
Then the cell changes are noticed if you type in the A1 and A2 cells.
Next read the user guide.
Cheers!

Thank you I will try this on…

By LupeDrums82

1 year 8 months ago

In reply to In ios I know. by Unregistered User (not verified)

Thank you I will try this on the iPhone version. I wonder if this way will work on Mac.

Formulas

By Kevin Shaw

1 year 8 months ago

Enter the cell you want the formula in. Type = (the equal sign) and start typing the type of formula you want: SUM, AVE for average, etc. You can arrow up and down to get to the formula you want and press return. Once you do this, you will be placed into the area where you can mark the cells for the formula.

Examples:
=SUM(B2:B14)
=AVERAGE(C2:H2)
=STDEV(C4:C20) (standard deviation)
Good luck!

More Like This

How can I insert a formula in numbers? (Forum Topic)
How to autofill cells with Numbers spreadsheet (Forum Topic)
How to stop row announcements in numbers? (Forum Topic)
Accessible money budget apps (Forum Topic)
Is there a Netflix or Hulu app for Mac? (Forum Topic)
Using Drummer in Garage Band version 10.3? (Forum Topic)
Screen Recording audio is only being heard through the ear piece and not through the speaker. (Forum Topic)
How to check diagnostics on Mac book pro? (Forum Topic)

Site Information

  • About
  • Club AppleVis
  • FAQ
  • Contact

Unless stated otherwise, all content is copyright AppleVis. All rights reserved. © 2023 | Accessibility | Terms | Privacy