Formulas......

[Anx]

I have this formula where if a cell has the word refurbished in it then a calculation is performed...

e.g.

=IF(H6="Refurbish",J6/100*'USER SHEET'!C19)

What i need to do is add a 'what if' the cell has the word "new" in it instead of refurbished and perform a different calculation, is it possible to add this to the existing formula please?


Also i need some help with dates....

How is it possible to work out how many months old date x is from a certain variable date y ?

e.g. I have a list of dates and need to work out how many months ago they are from another variable date.


Thanks for your help

Anx

 

[Anx]

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