if value begins with certain number

[ea223]

I need to write a formula in column c that says if the value in cell a1 begins with 55 then write "apple" in c1, otherwise if the value in cell b1 is higher than 100 write "banana1" and if it is less write "banana2"
Thank you!

[daddylonglegs]

You can use LEFT function to get the first 2 characters, i.e. with this formula in C1

=IF(LEFT(A1,2)="55","apple",IF(B1>100,"banana1","banana2"))

[ea223]

Perfect, thank you