![]() |
#1
|
|||
|
|||
![]()
Hello!
I have created a doc with a 3 merge fields and need to perform a calculation {={ MERGEFIELD "MERGE1"\# "€,0"}*(1+.04*{MERGEFIELD "MERGE2"}/{ MERGEFIELD "MERGE3"})} This returns the correct value to 2 decimal places with the €. How do I round it up to the next whole number please? Or better still round down to the next whole number? They are all number fields in the SQL database. Merge1 is a €number In my preview I am getting !Syntax Error, * Cheers in advance |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cathy1 | Excel | 2 | 01-22-2017 08:57 PM |
Custom rounding up | paulkaye | Excel | 8 | 09-03-2016 11:12 PM |
![]() |
melissapete24 | Excel | 5 | 08-27-2016 12:51 AM |
Rounding to nearest 0.25 | Guloluseus | Excel | 5 | 10-27-2015 11:28 PM |
![]() |
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |