If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|