Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Function
Hi What is the formula to get the following
Mark Points 90 & more 4 85 & less 90 3.7 82.5 & less 85 3.3 77.5 & less 82.5 3 75 & less 77.5 2.7 67.5 & less 75 2.3 67.5 & less 72.5 2 65 & lees 67.5 1.7 62.5 & less 65 1.3 60 & less 62.5 1 less 60 0 I mean when I put the mark in A1 cell the point appear in B1 cell many thanks EggHeadCafe - Software Developer Portal of Choice Run the command or application in the Security context of specified user http://www.eggheadcafe.com/tutorials...or-applic.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel Function from a Cell Through a Function | Excel Worksheet Functions | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions |