| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating a field based on what is in another column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub-Totalling Based upon a changing field | Excel Worksheet Functions | |||
| Pivot Tables..I give up... | Excel Worksheet Functions | |||
| Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) | |||
Threaded Mode
