Excel Formula to Word Table

[setoFairfax]

I'm having trouble converting an Excel formula to function in a Word
Table...I don't even know if the nested if statement is possible.

The Excel function is;
=IF(A2="","", IF(A2<100, 70, 70+ROUNDUP((A2-100)/100, 0)*25))

This function calculates inspection fees on utilities based on footage. All
inspections under 100ft are $70. Inspections over 100ft are $70 for the
first 100ft and then $25 for each 100ft thereafter. The first part of the IF
statement A2="","" just keeps the charge cell blank if there is no value in
the footage cell. The function may be more understandable here;

=IF(A2="","", <<keeps unused cells blank>>

IF(A2<100, 70, <<If the inspection is 100ft or less, it is $70>>

70+ROUNDUP((A2-100)/100, 0)*25)) <<for inspections greater than
100ft, the $70 base fee is applied, plus $25 for each additional 100ft (or
part of 100ft)>>

 

[Doug Robbins - Word MVP]

The simplest thing is probably just to use and Excel Spreadsheet in your
document rather than a Word table.

With a table, you would need the following field construction

{ IF { = A2 + 0 ] = 0 "" { IF { = A2 + 0 ) < 100 70 { = 25 * { = 70 + ( A2 -
100 ) / 100 \# "0" }}}}

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

Note the above does no actually round up the 70 + ( A2 - 100 ) / 100

Fellow MVP, Macropod has the field construction required to do the round up
in his Math Tutorial at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442

--
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