|
|
#2
04-04-2011, 05:30 PM
|
|||
|
|||
I would do it with an IF formula. If the score is in A1, then the formula would be:
=IF(A1<400,1,400/A1) With this formula, if the score is less than 400 the cell will produce a 1 (or 100% if it's formatted to percentage). If the score is greater than 400, the cell will display 400/score (e.g. 400/450 = 0.888889 = 89%). -SW 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 PMT Formula
|
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
|
Need help with a formula
|
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode