"IF" Formula Help


#1

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

Tnx!

:m:


#2

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.