AND(), OR(), and NOT() Functions explained for Apple Numbers!

[@Moshie71]

Thanks for this post, I'm currently paying for MS Office and suddenly thought ... I've got this (numbers) sat here doing nothing AND it's free! My only problem is everything just seems more difficult - I know the prompts are meant to be useful but when you're used to excel (functions) they just get in the way. I guess practice makes perfect. Keep up the good work.

[@apple-a-day]

Hi there! Yeah, I get that. Even though they more or less do the same thing, the approach to using Numbers and Excel are different enough to make it hard to learn. I haven't used Office in at least 10 years... I've been able to get by using the Apple suite (Numbers, Pages, Keynote). Thanks for watching!

[@JRossHunter]

I'm very much a Numbers noob. Is there a way in Numbers to write a series of parameters into a "macro" that could be saved and used in different spread sheets? I know it's very old, but that used to be fairly easy in a database program like dBase. Maybe AppleScript or the like is the way to go?

[@apple-a-day]

Great question! Unfortunately there's no built in macro functionality for Numbers but you can perform some tasks in AppleScript. I never used dBase but I did work in FoxPro back in the 90's - that was pretty similar. Anyway, this is a good idea for a future tutorial! Thanks for the comment!

[@JRossHunter]

@@apple-a-day I for one would welcome a tutorial. I seem to want to do the same or similar searches in different spreadsheets.