if cell not blank then

T

tmirelle

Need help with a mileage calculation

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

Can this be done?
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top