Functions

[Doug_Phipps]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to set up a function calculating FUTA payments from a cell containing total payroll until it Reaches $7000. I have been able to create the formula with the exception of when it becomes greater than $7000. For "else", I have been saying make it zero (0). Unfortunately this also blanks out all previous Futa records paid. How do I make it zero just going forward? Thanks for any assistance you can provide.

Doug

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to set up a function calculating FUTA payments from a cell
containing total payroll until it Reaches $7000. I have been able to create
the formula with the exception of when it becomes greater than $7000. For
"else", I have been saying make it zero (0). Unfortunately this also blanks
out all previous Futa records paid. How do I make it zero just going forward?
Thanks for any assistance you can provide.

Doug

Can you give an example of the formula and the source (column of) data?

A formula in one cell is not going to affect formulas in other cells, so
it's not clear exactly what is being "blank[ed] out" .

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to set up a function calculating FUTA payments from a cell
containing total payroll until it Reaches $7000. I have been able to create
the formula with the exception of when it becomes greater than $7000. For
"else", I have been saying make it zero (0). Unfortunately this also blanks
out all previous Futa records paid. How do I make it zero just going forward?
Thanks for any assistance you can provide.

It's not clear to me what your setup is, exactly - "a cell" sounds like
you've got a single cell calculating FUTA that should accumulate to $7K.
One way:

=MIN(<existing calculation>, 7000)

Without knowing what formula you're using, I'm not sure how it "blanks
out" previous calcs. But your use of "all previous Futa records paid"
sounds like a row or column of records with a FUTA calc done in each
record.

In that case, perhaps something like:

A B
1 Salary FUTA
2 $xx =MIN(A1*y%, 7000)
3 $xx =MIN(A2*y%, 7000-SUM($B$1:$B1))

copy B3 down as far as necessary.