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
|