Shawnnita wrote:
I'm trying to work on a family budget but I would like to know how to create a function in numbers where I divide the monthly into a weekly
Hi Shawnita,
Welcome to Apple Discussions and the Numbers '09 forum.
ISODD returns TRUE if a number IS ODD, FALSE if the number is even.
QUOTIENT returns the quotient of a division problem and ignores the remainder, if any.
example: =QUOTIENT(7,2) returns 3
For most division, you'll want to use the division operator ( / ) rather than the QUOTIENT function.
=7/2 returns 3.5
Suppose your monthly amount is in cell B2 and you want the weekly amount in cell D2.
You could use =B2/4 in cell D2
But that assumes each month has (exactly) four weeks.
As that's true only for February, you'd be better to calculate a daily amount, then multiply that by seven to get a weekly amount.
Enter the number of days in the current month into C2, and revise the formula in D2 to
=(B2/C2)*7
(This formula also uses the multiplication operator ( * )
I'm very new to spreadsheets in general and numbers in particular.
One of the best pieces of advice I can give you is to launch Numbers, go to the Help menu and choose Numbers '09 User Guide. Then go to the same menu and choose iWork Functions and Formulas User Guide.
Read at least the first chapter of the Numbers '09 User Guide, and read the other chapters when their chapter titles suggest they may contain something you need to know for what you're trying to do.
The Functions and Formulas User Guide is more of a reference with explanations and examples. Use it when you want to know how to enter a function or how to build a formula.
Regards,
Barry
