Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - Setting up a formula
I am setting a following formula:
=IF(AB187,"A",IF(AB184,"B+",IF(AB178,"B",IF(AB1 72,"C",IF(AB1<73,"F",0))))) for grades of student. It gives me error. For example. If student got 87 he should have B+ according to formula. However, excel gives me "A" instead of B+. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - Setting up a formula
Hi,
For 87 the formula will return B+. If 87 is returning A then what you see in the cell probably isn't what's actually there. It may be (say) 87.1 but you may not be able to see the decimal part because of formatting. Try this. Put 87 in another cell (say)AC1 and try this formula =AC1=AB3 If AB3 is really 87 the formula will return TRUE. If it returns false then that's the problem. You could overcome that with this formula =LOOKUP(INT(AB1),{0,73,79,85,88},{"F","C","B","B+" ,"A"}) Mike "NS" wrote: I am setting a following formula: =IF(AB187,"A",IF(AB184,"B+",IF(AB178,"B",IF(AB1 72,"C",IF(AB1<73,"F",0))))) for grades of student. It gives me error. For example. If student got 87 he should have B+ according to formula. However, excel gives me "A" instead of B+. Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - Setting up a formula
I get B+, but a better formula is
=LOOKUP(AB1,{0,"F";73,"C";78,"B";84,"B+";88,"A"}) -- __________________________________ HTH Bob "NS" wrote in message ... I am setting a following formula: =IF(AB187,"A",IF(AB184,"B+",IF(AB178,"B",IF(AB1 72,"C",IF(AB1<73,"F",0))))) for grades of student. It gives me error. For example. If student got 87 he should have B+ according to formula. However, excel gives me "A" instead of B+. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I PLEASE NEED URGENT HELP WITH A FORMULA!!! | Excel Worksheet Functions | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
If formula - URGENT | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Urgent Formula! | Excel Discussion (Misc queries) |