943,525 Members | Top Members by Rank

Hardware and Software > Microsoft Windows > Windows Software > Formula in Excel 2007
Ad: Download a FREE TFTP Server Tool for Network Configuration from Spiceworks
Permalink
Feb 18th, 2009
0

Formula in Excel 2007

Expand Post »
Hi THere

Looking for some assistance - I've had a need to use anything other than very basic formulas in Excel, but I'm now struggling to generate the information that I want.

In the attachment formula, I have some ratings, and have calculated, in column entitled Diff, the difference between the highest rating, an each of the others. Now I'm looking to automatically add the decimal odds from the doc entitled appendix_6...

Therefore, a score of 0 in column named Diff would result in a total of 1.00 being placed in the Decimal Odds column of the same sheet, and:

Diff = 1, therefore Decimal Odd = 0.9
Diff = 2, therefore Decimal Odd = 0.8

Which formula would assist me in producing this data easily?
Any assistance greatly appreciated.
Attached Files
File Type: pdf appendix_6.pdf (27.7 KB, 22 views)
File Type: pdf formula.pdf (25.8 KB, 28 views)
Similar Threads
Reputation Points: 11
Solved Threads: 1
Light Poster
Borderline is offline Offline
49 posts
since Apr 2008
Permalink
Feb 18th, 2009
1

Re: Formula in Excel 2007

From what you described, it sounds like the VLOOKUP function will work.

You give VLOOKUP a value, a range and a return column. The function will then look for the value in the range and then return the corresponding value in the column you specified. If you look it up in Microsoft Excel's help, you should be able to figure out how it works.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Permalink
Feb 18th, 2009
0

Re: Formula in Excel 2007

Excellent, many thanks! Got phase one working.

I'm now working on a second part: it involves pulling data from a different table, but the "lookup" data won't be exactly the same as the stored information.

Therefore, I'm trying to retrieve the nearest match for the lookup data. I tried the vlookup formula, but replaced false with true, but this results in: #N/A

Could you offer any advice on this problem, please?
Reputation Points: 11
Solved Threads: 1
Light Poster
Borderline is offline Offline
49 posts
since Apr 2008
Permalink
Feb 18th, 2009
0

Re: Formula in Excel 2007

Problem solved - silly error, was including the title heading.

Thanks again for your help, the formulas will save me a heap of time!
Reputation Points: 11
Solved Threads: 1
Light Poster
Borderline is offline Offline
49 posts
since Apr 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Windows Software Forum Timeline: 4 typical questions about inserting music to PowerPoint
Next Thread in Windows Software Forum Timeline: Very confused on Verizon & Outlook





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC