Brian - the formula *round[PxFx;1]* will do exactly that.



2011/9/14 Brian Finn <[email protected]>

>  I need assistance creating a formula that will roundup a (G-$ZZ9.99) Field
> a whole dollar, any suggestions?
>
> Thank You
> --
>
>  Brian Finn
> Client Services / Database Administrator
> Local: 602-712-1515 Fax: 602-246-1782
> Toll Free: 1-866-332-8453
> Arizona Contractor License Center
>  [image: Arizona Contractor License Center website] <http://www.azclc.com>
>  [image: Follow AZCLC on 
> Facebook]<http://www.facebook.com/pages/Arizona-Contractor-License-Center/107148999306616>[image:
> Follow AZCLC on Twitter] <http://twitter.com/ArizonaCLC>[image: Keep up to
> date with AZCLC] <http://www.arizona-clc.com/>[image: AZCLC 
> Blog]<http://www.azclc.com/blog.xml>
>
>
>
>
>
> _______________________________________________
> Dataperf mailing list
> [email protected]
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
>


-- 
*Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA   15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax*

<<facebook.png>>

<<twitter.png>>

<<rss_icon.png>>

<<reach_cast.png>>

<<23_5eef08f759bb5d47e094b9fb828ef8ed.jpg>>

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to