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
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