Calculating a field based on what is in another column

A

acs68

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
 
A

Alan Perkins

Assuming your data is in columns A and B, one way:

=A1*INDEX({0.5,100,0.01},1,MATCH(B1,{"F","W","Y"},0))

HTH

Alan P.
 
Top