Nested IF Formula

[Thomas]

I have 2 formulas that work great in Excel. How do I get them to work in a
Word table?
1 - =IF(C24=1,950,IF(C24<19,(30-C24)*C25,"N/A"))
2 -
=IF(C24=15,950,IF(C24=31,443.33,IF(C24<4,(15-C24)*C25,IF(C24>14,(950-(C24-14)*C25),"N/A"))))

I made this for the first one
{IF{A2}="1""950.00""{IF"A2}<"19""{30-A2}*B2"}"}
and I think it works, but I do not know if this is the easiest or smartest
way to write it. And I cannot get the second one to work.

Please Help

 

[Doug Robbins - Word MVP]

The following works for me:

{ IF { = A1 } = 15 950 { IF { = A1 } = 31 433.33 { IF { = A1 } < 4 { = (15 -
A1) * A2 } { IF { = A1 } > 14 { = (950 - (A1 - 14) * A2) } "N/A" }}}}

--
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, originally posted via msnews.microsoft.com