Convert Google sheets/Excel formulas to Numbers

I just noticed that the currency values in your screenshot use the comma as the decimal. This means you are likely NOT in the US. therefore you should change argument separators we are posting as commas to semicolons.

e.g.

where I posted:

B2=B1/DAYS360(B3,B4+"1d",FALSE)

you should enter:

B2=B1/DAYS360(B3;B4+"1d";FALSE)

same comment for formulas from others posting formulas to help you.

I think the template is designed using the excel/google doc concept of a sea-of-cells view of a spreadsheet. The Numbers way is to use finite size tables and organize data in individual tables.

Here is a focused example of how to modify the discretionary spending table:

Create a new table with a single header column (and name the table "Setup" as shown

select cell B4, then type, or copy and paste from here, the formula:

=EDATE(B3, 1)

shorthand for this is:

B4=EDATE(B3, 1)

B2=B1/DAYS360(B3,B4−"1d",FALSE)

Now create a other table with a single header row and name the table "Discretionary Activity":

select cell E2 and type, or copy and paste from here, the formula:

=(ROW()−1)×Setup::$B$2−SUM($C$2:C2)

shorthand for this is:

E2=(ROW()−1)×Setup::$B$2−SUM($C$2:C2)

select cell E2, copy

select cells E2 thru the end of column E, paste

now enter values i the expense column as needed. (you really do no need the Daily allowance column, so I left it blank)

well.... no... you see regions of the world have differences that have consequences. In the US, for example, we us the period for the decimal, and the comma to separate arguments in the function. In your region, you use the comma as an decimal. So when you use the formula I posted, Number is "confused" by a decimal in weird place.

Numbers does all you to change you region for a file using the Number menu item "File > Advanced > Language & Region":

You could use this feature to temporarily change to match those helping you, then change it back. You could also mention your region in posts to help in the future. Many of us know to watch for this however, on occasion, we miss the initial clues.

All the best,

Wayne

Additional modification to the table "Setup":

B2=B1÷DAYS360(B3,B4+"1d",FALSE)

Additional modifications to the table "Discretionary Activity":

A2=Setup::$B$3

A3=IF(A2<(Setup::$B$4−"1d"), A2+"1d", "")

select cell A3, copy

select cell A3 thru the end of column A, paste

E2=IF(A2="", "", (ROW()−1)×Setup::$B$2−SUM($C$2:C2))

copy and paste to fill cell E2 down like previous process

To your original question, what is not working about the formulas? They appear to be perfectly valid formulas for Numbers.

I copy/pasted your spreadsheet into a Numbers document which created a copy that was like "paste formula results" then copy/pasted formulas to the necessary cells and the formulas worked, giving me the same results as in your table.

Is the problem related to the region? In your imported (?) spreadsheet in Numbers, do actual decimal numbers use the point or a comma? Are the "numbers" with decimal points that you have typed in yourself (not from formulas) aligning on the left side of the cell (like text) or right side (like numbers)? When you select one of those cells, at the bottom of the screen does it say "actual" or "text"?