Hi everyone,

I have a 3 column spreadsheet.

Amount Frequency Weekly$ (Calculated)

1200 F 600 i.e. divides it by 2 if F
100 W 5200 i.e. times it by weeks in
year
5200 Y 100 ie divides it by weeks in
year

As you can see, I want the Weekly$ amt to be calculated based on whether the
Frequency is W (Weekly), F (Fortnightly) or Y (Yearly).

any ideas as to what to do ?

cheers,

Adam