Help with LEFT formula

Leslie Ambs

I am trying to extract the left most character in a case number column and if it is "F" then enter "Fraud", if the leftmost character is "C", then enter "FIU" in the Function column.

heyjay

=IF(LEFT([Evaluation Date]@row) = "F", "Fraud",
 IF(LEFT([Evaluation Date]@row) = "C", "FIU", 
""))

heyjay

=IF(LEFT([Evaluation Date]@row) = "F", "Fraud",
 IF(LEFT([Evaluation Date]@row) = "C", "FIU", 
""))

Leslie Ambs

this worked! (albeit I changed "evaluation date" to "Case Number". thank you!!