Price per day - Word 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Stammers - 14 May 2007 16:30 GMT

Hello,

I have to work out a 'pence per day' figure in a merge. I have come up with
this formula - could someone tell me if it looks right please?

{ = ({ MERGEFIELD myamount }/30) * 100 \#"00p" }

Thanks,
Chris

Reply to this Message

Peter Jamieson - 14 May 2007 16:47 GMT

Assuming you're starting with a "pounds&pence per month" figure it looks OK
to me. You only really need "00p" if you always want at least two digits
before the "p". If you're happy with 1p, 23p, 456p, you should be able to
use "0p".

Peter Jamieson

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks,
> Chris

Reply to this Message

Chris Stammers - 14 May 2007 17:24 GMT

Thanks Peter. Is that always the case with 'pence' formatting? It will always
only ever need to be 15p or 20p - 2 digit amounts anyway. In one of my last
questions, you gave me the formula to take the decimal point away and just
leave the 'pence'. Can I apply your detail below to that query as well?

Thanks,
Chris

> Assuming you're starting with a "pounds&pence per month" figure it looks OK
> to me. You only really need "00p" if you always want at least two digits
[quoted text clipped - 13 lines]
> > Thanks,
> > Chris

Reply to this Message

Peter Jamieson - 14 May 2007 17:36 GMT

Yes, if you have \#"0" it just means "always have at least one digit"

> Can I apply your detail below to that query as well?

Yes. These switches are all covered in Word Help, at least in Word 2003.

Peter Jamieson

> Thanks Peter. Is that always the case with 'pence' formatting? It will
> always
[quoted text clipped - 24 lines]
>> > Thanks,
>> > Chris

Reply to this Message

Rate this thread: