View Single Post
 
Old 09-16-2014, 03:34 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

Given that all the fields are the same, why not just bookmark the first one, then insert cross-references to that one bookmark? You certainly don't need to bookmark every field. Indeed, you don't need to bookmark any of them if all you're going to do is replicate the formula field wherever you want the output repeated.

Now, suppose you bookmark just the first instance, with 'RPM' as the bookmark name. In that case, wherever you want the same results to appear, simply insert a cross-reference to the RPM bookmark. Done.

To output the RPM +/- 10, simply use another formula field, coded as:
{=RPM+10}
or:
{=RPM-10}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote