"IF" Formula Help

[Miroslav_Tunjic]

Hi all!

I am stuck with a rather simple problem…

Payroll,

If you make more money in the month than you should, then transfer the overhead to the next month, example:
Salary January= 2000$

• if jannuary is 2400$, then 2000$ in jan, and transfer 400$ to feb

Here is a simple DB link

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Tnx!

:m:

[W_Vann_Hall]

Based on your base (so to speak), I’d create a second formula field for each month that would represent gross income. The formula would be something along the lines of

{PreviousMonthGross}-{PreviousMonthNet}+({ThisMonthHours}*{HourlyPay})

The formula for {ThisMonthNet} would be

MIN({ThisMonthGross},2000)

That’s assuming you can do all your math within each record — that is, each record contains multiple months’ worth of data for an individual. If you need to perform cross-record calculations, it’s still possible… just more difficult.