View Single Post
 
Old 03-13-2019, 03:22 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For the most part, all you should need to do is copy & paste the example from that document as-is, rather than trying to reconstruct the entire field yourself.

As for the output, maybe you should consider using logarithmic values for the output. That way the re-scaling is both progressive and automatic. To see how to do that in Word, check out the Logarithms topic in my Microsoft Word Field Maths Tutorial: https://www.msofficeforums.com/word/...-tutorial.html. Otherwise, all you need to add is a single IF test that divides the merged value by a given constant if it exceeds 10.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote