Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.word.tables




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((A2100)/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((A2100)/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
Posted to microsoft.public.word.tables




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/cgibin/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((A2100)/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((A2100)/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  


Similar Threads  
Thread  Forum  
Can word do this formula =EXP(B2) in a table?  Tables  
Formula from Excel to Word  Microsoft Word Help  
how do I get this formula (A2*d2)e2 in a word table  Tables  
excel formula table into word  Microsoft Word Help  
Excel formula to word  Microsoft Word Help 