Hi

I have three cells in a single worksheet that represent a weekly, monthly
and annual sales target. Does anyone know the formula to ensure that if a
target is eneterd in any of three cells, the other two are automatically
calculated.

For example, if I enter a weekly target, the monthly target is calculated by
multiplying the weekly figure entered by 52 and dividing by 12. This should
also calculate the annual figure in the third cell.

The part I can't work out is how to allow the target to be entered in any
three cells and the other two be automatically calculated.

Any ideas would be greatly appreciated.

Thanks
Simon