Formula problem!!!

[ace323]

I need help with a formula to calculate fringe benfits. I need it to do the following, I just can't seem to get the function to work right.

If "gross pay" is < 1056.00 then do nothing. If its > 1056.00 then calculate the gross pay as 1056.

 

[Turkbear]

Hi,
How is that calculating anything?
If you want to eliminate the decimals, then conditionally format the display..

Give an example of what you want to do...







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Do you mean this?

if {table.pay} > 1056 then
1056 else
{table.pay}

-LB