| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas from Quattro Pro in Excel 2007
I can't seem to unravel the following formula from Quattro Pro so that they
will work in Excel. Quattro Pro Cell L8: @IF(D80,(D8*J8)+K8,) Cell M8: @IF(E80,(E8*J8)-K8,) Cell N8: @IF(G80,(G8*J8)+K8,) Cell O8: @IF(F80,(F8*J8)-K8,) Cell P8: @IF(B80#OR#C80,+L8+N8,) Cell Q8: @IF(B80#OR#C80,+M8+O8,) Cell A9: @IF(Q80,A8+Q8,@IF(P80,A8-P8,) Access Excel 2007 Cell L8 : =IF(D80,(D8*J8)+K8,"") Cell M8 : =IF(E80,(E8*J8)-K8,"") Cell N8: =IF(G80,(G8*J8)+K8,"") Cell O8: =IF(F80,(F8*J8)-K8,"") Cell P8; =IF(L80,L8,IF(N80,N8,"")) Cell Q8: =IF(M80,M8,IF(O80,O8,"")) Cell A9: =IF(P80,A8-P8,IF(Q80,A8+Q8,"")) And from what I've read so far; I don't think a VBA macro is what I'm looking for. The above formula worked fine in Quattro Pro. -- Thanks; in advance, Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quattro converter for Excel 2003 | Excel Discussion (Misc queries) | |||
| Quattro Pro vs Excel | Excel Discussion (Misc queries) | |||
| converting to Excel from Quattro Pro | Excel Discussion (Misc queries) | |||
| excel vs quattro | Excel Discussion (Misc queries) | |||
| File Converter Quattro Pro to Excel | New Users to Excel | |||
Threaded Mode
