Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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)
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can word do this formula =EXP(B2) in a table? GT Tables 1 August 8th 07 01:43 AM
Formula from Excel to Word Tywardreath Microsoft Word Help 3 July 21st 06 09:52 AM
how do I get this formula (A2*d2)-e2 in a word table Big dogs Tables 2 April 22nd 06 12:03 PM
excel formula table into word Krohm Microsoft Word Help 1 April 26th 05 02:00 PM
Excel formula to word Steved Microsoft Word Help 3 April 3rd 05 08:43 AM


All times are GMT +1. The time now is 08:31 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"