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
|
|||
|
|||
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 |
#2
|
|||
|
|||
Nested IF Formula
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 "Thomas" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|