[tmirelle]

Need help with a mileage calculation

If cell 'c1' ia not blank then cell 'd1' needs to include .47

Can this be done?

[Doug Robbins - Word MVP]

There is a bit of a problem with this as the cell of a table is never really
blank as it always contains an "end-of-cell" marker. If the entry in C1 is
likely to be numeric, you can get around the problem by adding 0 to it and
then checking if the result is 0. To do that, put the following formula in
Cell d1

{ IF { = C1 + 0 } 0 ".47" "" )

You must use Ctrl+F9 to insert each pair of field delimiters { }.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"tmirelle" wrote in message
...
Need help with a mileage calculation

If cell 'c1' ia not blank then cell 'd1' needs to include .47

Can this be done?