Its ok my mistake, i got it working...


=IF(H6="Refurbish",J6/100*'USER SHEET'!$D$20,IF(H6="New",J6*1))

and the date formula...

=(YEAR('USER SHEET'!$D$6)-YEAR(I6))*12+MONTH('USER SHEET'!$D$6)-MONTH(I6)

Thanks guys


[ This Message was edited by: Anx on 2002-04-15 17:13 ]