Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i'm trying to put a value with a number but its not working.
i'm trying to put a value of a number to print out a letter such as 93 to
100=A, and so on here is what I have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if( then(b28<=70,"D"),if(then(b28=69,"f"))), what do i have wrong. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i'm trying to put a value with a number but its not working.
see answers in programming. Pls only post in ONE group
-- Don Guillett SalesAid Software "dave" wrote in message ... i'm trying to put a value of a number to print out a letter such as 93 to 100=A, and so on here is what I have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if( then(b28<=70,"D"),if(then(b28=69,"f"))), what do i have wrong. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i'm trying to put a value with a number but its not working.
Dave
To convert scores to letter grades use a Lookup table and VLOOKUP functions. OR a Lookup formula without a table Assuming scores are in column A starting at A1. In B1 enter this formula then drag/copy down column B =LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"}) Example only. Adapt for your scores and grades. Note the curly braces internally. Gord Dibben MS Excel MVP On Sat, 8 Apr 2006 09:44:02 -0700, dave wrote: i'm trying to put a value of a number to print out a letter such as 93 to 100=A, and so on here is what I have,=IF(B28=93,"a","B"),if(then(B28<=85,"c"),if (then(b28<=70,"D"),if(then(b28=69,"f"))), what do i have wrong. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
calculate number of working days | Excel Worksheet Functions |