Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF functions
i have another problem
what is the formula if i have three grades and in A1.B1 & C1. i need a final grade answer in D1. I need a formula which could result in any of the answers below related to the recorded grade A B C D 1 P M D = Distinction or A B C D 1 P M X = Merit or A B C D 1 P x x = Pass or A B C D 1 x x x = Refer hope someone can help tomo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions
Try something like this:
D1: =CHOOSE(MAX(SEARCH(A1:C1,"XPMD")),"Refer","Pass"," Merit","Distinction") Note: Commit that array formula by holding down the [Ctrl][Shift] keys and press [Enter]. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "tomo" wrote: i have another problem what is the formula if i have three grades and in A1.B1 & C1. i need a final grade answer in D1. I need a formula which could result in any of the answers below related to the recorded grade A B C D 1 P M D = Distinction or A B C D 1 P M X = Merit or A B C D 1 P x x = Pass or A B C D 1 x x x = Refer hope someone can help tomo -- tomo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) |