Calculating a field based on what is in another column

  • Thread starter Thread starter acs68
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Averages based on criteria 6
Populate excel sheet based on values in a separate sheet 3
Calculate Goal each day 7
Copy values from a cell based on values of another cell 4
Help Arranging Data on Spreadsheet 2
Pivot Table Calculation based on 2 columns 3
Access MSACCESS - Sorting report based on field calculated in the report 0
Formula to sum based on a change in another column 2

Back
Top