try these ideas
Cell "L8": =IF(D80,(D8*J8)+K8,"")
Cell "P8": =IF(or(B80,C80),L8+N8,"")
Cell "A9": =IF(Q80,A8+Q8,IF(P80,A8-P8,""))

--
Don Guillett
SalesAid Software

"Richard" wrote in message
...
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