View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
Thomas Thomas is offline
external usenet poster
 
Posts: 35
Default Nested IF Formula

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(C2419,(30-C24)*C25,"N/A"))
2 -
=IF(C24=15,950,IF(C24=31,443.33,IF(C244,(15-C24)*C25,IF(C2414,(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