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((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 | |
|
|
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 |