Hello,
I am helping out with some admin work on a volunteer basis with the swimming club that my daughter attends. Each swimmer is eligible for various badges depending on what time they swim in each event - i.e. a Bronze, Silver, Gold or Platinum badge subject to swimming a certain time.
I am trying to make a tool in Excel 2007 that calculates what badge they have got for each event.
Cell A1 is titled STROKE, Cell B1 is DISTANCE, Cell C1 is TIME and Cell D1 is BADGE
In Cell A2 I have used a drop-down box to select Backstroke, Freestlye etc...
In Cell B2 I have used a drop-down box to select 50 metres, 100 metres etc...
Cell C2 is a manual input cell based on the time recorded in each race.
Cell D2 is the cell that I would like a formula for/some help on.
The formula needs to be something like "If Cell A2 is Backstroke and Cell B2 is 50 metres and the time in C2 is xx.xx then D2 is Gold.
If for example Bronze was 60 seconds to 55 seconds, Silver was 54.9 seconds to 50 seconds, Gold was 49.9 seconds to 45 seconds and Platinum was 44.9 seconds or less - would this give one of you enough information to come up with something clever?
Any help greatly appreciated!
Not got access to a copy of Excel at the moment, but you could probably use SUMPRODUCT, or INDEX/MATCH, possibly using a helper column.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Don't upload a picture when you have a workbook. None of us is inclined to recreate your data. Upload the workbook and manually add an 'after' situation so that we can see what you expect. In addition clearly explain how you get the results.
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.
On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.
You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.
To upload a file from your computer, click the 'Browse' button and locate the file.
To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Here's a file that does what you want.
You'll have to adapt all the formulas to fit your worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks