If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculate Score by function
what should I have to do if i want to give score 5 at 1000
and with every increase or decrease of 25 in 1000 .25 should be added in 5 or subtracted respectively. Thanks Shw |
#2
|
|||
|
|||
calculate Score by function
Hi
if your vcalue is in A1 try the following formula =FLOOR(A1-500,25)/25*0.25 or shorter make this =FLOOR(A1-500,25)/100 -----Original Message----- what should I have to do if i want to give score 5 at 1000 and with every increase or decrease of 25 in 1000 .25 should be added in 5 or subtracted respectively. Thanks Shw . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Modifying Tab Order | Joan McDonald | New Users | 7 | June 11th, 2004 11:19 PM |
My own function cannot be exported. | Christian | Worksheet Functions | 0 | November 26th, 2003 03:22 PM |
set cell format in user function | Vasant Nanavati | Worksheet Functions | 0 | November 24th, 2003 03:33 PM |