View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
setoFairfax setoFairfax is offline
external usenet poster
 
Posts: 1
Default Excel Formula to Word Table

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(A2100, 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(A2100, 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)