If you want to allow any one of the cells to be entered and the other two
calculated, I think doing this entirely with formulas would require circular
references. I'd either use VBA to detect the data entry (the
worksheet_change event) and fill in the other two cells or separate the input
cells from the three different output cells.
If you choose the latter approach, I'd probably provide two input cells, one
for the target and the other a dropdown (using data validation) to select
'Per Week', 'Per Month' or 'Per Year'. Then I'd calculate the annual target
based on those two cells, and the weekly and monthly goals by multiplying the
annual target by 1/52 and 1/12, respectively.

"Pieman" wrote:

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