How to use formulas for Numbers on iPhone and iPad

How to use formulas and functions in Numbers spreadsheets on iPhone and iPad.

Besides simply keeping large amounts of numerical data well organized, the true utility of a spreadsheet lies in its ability to easily manipulate the data to derive sums, averages, maximums and so on. To do this, you need to use formulas in certain spreadsheet cells. For a simple example, you could have the prices of all the items you've sold on Ebay in column A and their shipping costs in column B.

Fortnite Live is the Fyre festival of video game events

Fortnite Live

Attendees of the first ever Fortnite Live festival were disappointed with the event complaining about long lines and lackluster attractions. The two-day festival, which took place at the Norfolk showground near Norwich, was advertised as "a celebration of the Fortnite game organised by fans for fans." Hundreds of people have demanded refunds after paying $15 to $20 for unlimited wristbands.

Parents were surprised to learn that the event only featured a few fairground attractions with limited space for children to participate. Photos posted to social media showed a "cave experience" that was only a truck with a tarp draped over it. Other "attractions" included a single climbing wall for over 3,000 children, four go karts and archery for four people.

Reports: AirPods 2 with upgrades coming soon

Space Gray AirPods ColorWare

Apple is set to deliver redesigned AirPods with hardware upgrades for the first time since the wireless ear buds launched in 2016. Reports have been surfacing from the supply chain and elsewhere, pointing to what's ahead for AirPods 2, and when they might arrive for purchase. Here's a roundup of what's expected from the next generation AirPods.

How to make your own Shortcuts on iPhone - This one will show your photos from this day on every year

How to program your own shortcuts on iPhone and iPad.

Shortcuts is Apple's new version of Workflow that launched with iOS 12. It is a productivity tool that does what its name implies - each shortcut is basically a program or 'workflow' that runs through a set of steps to produce a desired result. For example, Home ETA is a navigation shortcut that uses Maps and Messages to send someone (pre-determined by you) your arrival time with a single tap.

How to password protect your Pages, Numbers and Keynote documents on iPhone and iPad

How to require a password for Pages, Numbers and Keynote documents on iPhone and iPad.

Unless you have been living in a cave since the early 90s you know that cyber security is a huge issue and that you should protect your data as well as you possibly can. If you are sending private information in documents and spreadsheets over the internet via email, Dropbox, iCloud or any other service, it becomes vulnerable, regardless of how secure you think the medium is. And who knows how the recipient will handle the info?

Pages

Subscribe to The iPhone FAQ RSS