Countif Problem

[SteveG]

I want to have a cell return a text value based on multiple conditions
text and numeric, for multiple cells. i.e. if cell a3 = 1 and cell b3
2 and cell c3=Full-Time then cell c4 = text, if not then go to nex
string of conditions, if cell a3 = 2 and cell b3 =4 and cell c3 =
then text. I am sure there is an easy answer to this one but it i
driving me nuts. Any help would be greatly appreciated.

Thanks!
Stev

 

[Guest]

Hi,
Not clear what text you require in destination cell.
Maybe
1 2 Full-Time
formula C4: =A3&" "&B3&" "&C3

in code to check values something like

Sub aaa()
Dim myRange As Range
Set myRange = Range("A2")
If Application.WorksheetFunction.IsNumber(myRange) Then
MsgBox "Number"
ElseIf Application.WorksheetFunction.IsText(myRange) Then
MsgBox "Text"
End If
End Sub

Peter Scott

 

[SteveG]

Peter,

I don't fully understand your reply. I am kind of new to many of th
formulas etc... I'll try again to give you better information.

I have 4 coulumns, A, B C, D. The formula needs to return the tex
value of either "Pass" or "Fail" in column D depending on what value
are in the other 3.

The issue I am having is that there are multiple criteria so th
formula has to check the 4 columns for multiple scenarios all befor
reaching its final result.

Example:
An employee has to take certain certification courses(assigned number
1 through 18) and depending on what level the employee is (1, 2, 3 o
4) and what the course is, they need to get different scores in orde
to pass.

IF A1=Level 1&B1<=12&C1>=80%, "Pass" - or -
IF A1=Level 2&B1>12<15&C1>=90%, "Pass" - or -
IF A1=Level 3&B1>=<17&C1>=95%, "Pass" - or-
IF A1=Level 4&B1=18&C1=100%, "Pass"

but if the criteria of A & B does match but the C value does not, the
it should return the text value "Fail".

I either just made this worse or hopefully explained his better.

Thanks for your help.
Stev

 

[Guest]

Steve,
Email sent to (e-mail address removed)
with Excel File. If not received post reply here
Peter