Reply
 
Thread Tools Display Modes
  #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)
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Excel Formula to Word Table

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/show...?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

"setoFairfax" wrote in message
...
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)



Reply
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 10:45 PM.

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

About Us

"It's about Microsoft Word"