| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting formula from Lotus123 to Excel
I need some help. I am trying to convert a Lotus formula into Excel, but Excel will not convert it. The Lotus Formula is:
@IF(A87=1000#AND#($D$2-IU87)0#AND#IV87="",(@IF((D87$D$3),(D87-$D$3),"")),D87) Unfortunately I do not know enough about Lotus formulas to understand this one. I would be greatly appreciative if anyone can help me figure out the Excel conversion. Thanks! Lisa V |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel and Lotus123 | Excel Discussion (Misc queries) | |||
| How do I bring Lotus123 files over in to Excel | Excel Discussion (Misc queries) | |||
| How do I import data from lotus123 & maintain formulas/worksheets | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| Lotus123 to Excel | Excel Programming | |||
Threaded Mode
