| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested For Next | Microsoft Word Help | |||
| how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
| nested if then else | Microsoft Word Help | |||
| Nested If | Mailmerge | |||
| if and vlookup in a nested formula | Microsoft Word Help | |||
Threaded Mode