I learned to write formulas in the numbers app using the extensive health system which describes functions formulas and all the syntax they’re in. I did have a lot of experience in Excel spreadsheet in and he did carryover. I was also a programmer many moons ago and I suppose that helps a bit too. Check out the health system and just weighed in, it’s pretty well organized and you can find various formula is categorized according to their purposes. Then it’s just a matter of using your own creativity checking out the documentation on the functions and experimenting to see if it works. Like I said earlier a lot of work for kind of a little bit of return. But if you got the time there you go
Sent from my IPhone > On Feb 26, 2018, at 8:44 PM, David Chittenden <[email protected]> wrote: > > Many formuli work the same in Numbers as they do in Excel. I would try the > Excel instructions and see if they work for Numbers in your use case. > > Kind regards, > > David Chittenden, MSc, MRCAA > Email: [email protected] > Mobile: +61 488 988 936 > Sent from my iPhone > >> On 27 Feb 2018, at 11:01, Alex Hall <[email protected]> wrote: >> >> My day job is part coder, part IT guy, so formulas don't bother me. I'm not >> sure where to start, though, and I could only find threads about my question >> that talked about Excel, not Numbers. >> >> -- >> Alex Hall >> >> >> >> >>> On Feb 26, 2018, at 09:00, Phil Halton <[email protected]> wrote: >>> >>> That depends, how good are you at writing spreadsheet formulas? In my >>> experience you probably be better off just manually entering the date, such >>> as 2/26, for February 26. It is, after all, just one more field to fill-in >>> as opposed to some fairly tricky formula writing. >>> >>> Sent from my IPhone >>> >>> >>>> On Feb 25, 2018, at 8:47 PM, Alex Hall <[email protected]> wrote: >>>> >>>> Hi all, >>>> This is a bit off topic, but I can't think of a better place for a Numbers >>>> question. >>>> >>>> On macOS, I need to keep a log for the next few weeks, updated daily. I'm >>>> making a spreadsheet, and I'd like the first column to fill itself with >>>> the current date whenever I enter values on the row. That is, if the first >>>> column is the date, I want that first cell to be populated with the >>>> current date if I enter any value in any other cell for a row. I hope this >>>> is making sense. Can it be done? Thanks! >>>> >>>> -- >>>> Alex Hall >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> The following information is important for all members of the Mac >>>> Visionaries list. >>>> >>>> If you have any questions or concerns about the running of this list, or >>>> if you feel that a member's post is inappropriate, please contact the >>>> owners or moderators directly rather than posting on the list itself. >>>> >>>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: >>>> [email protected] and your owner is Cara Quinn - you can reach Cara at >>>> [email protected] >>>> >>>> The archives for this list can be searched at: >>>> http://www.mail-archive.com/[email protected]/ >>>> --- >>>> You received this message because you are subscribed to the Google Groups >>>> "MacVisionaries" group. >>>> To unsubscribe from this group and stop receiving emails from it, send an >>>> email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/macvisionaries. >>>> For more options, visit https://groups.google.com/d/optout. >>> >>> >>> -- >>> The following information is important for all members of the Mac >>> Visionaries list. >>> >>> If you have any questions or concerns about the running of this list, or if >>> you feel that a member's post is inappropriate, please contact the owners >>> or moderators directly rather than posting on the list itself. >>> >>> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: >>> [email protected] and your owner is Cara Quinn - you can reach Cara at >>> [email protected] >>> >>> The archives for this list can be searched at: >>> http://www.mail-archive.com/[email protected]/ >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> The following information is important for all members of the Mac >> Visionaries list. >> >> If you have any questions or concerns about the running of this list, or if >> you feel that a member's post is inappropriate, please contact the owners or >> moderators directly rather than posting on the list itself. >> >> Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: >> [email protected] and your owner is Cara Quinn - you can reach Cara at >> [email protected] >> >> The archives for this list can be searched at: >> http://www.mail-archive.com/[email protected]/ >> --- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > -- > The following information is important for all members of the Mac Visionaries > list. > > If you have any questions or concerns about the running of this list, or if > you feel that a member's post is inappropriate, please contact the owners or > moderators directly rather than posting on the list itself. > > Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: > [email protected] and your owner is Cara Quinn - you can reach Cara at > [email protected] > > The archives for this list can be searched at: > http://www.mail-archive.com/[email protected]/ > --- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this list, or if you feel that a member's post is inappropriate, please contact the owners or moderators directly rather than posting on the list itself. Your Mac Visionaries list moderator is Mark Taylor. You can reach mark at: [email protected] and your owner is Cara Quinn - you can reach Cara at [email protected] The archives for this list can be searched at: http://www.mail-archive.com/[email protected]/ --- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
