a "Begins with" IF formula

[Shales]

Lets say that I have different letters in A1:A10 and a list of numbers in B1:b10.

I am looking for a formula along the lines of;

If A1:10 = x then C1 = "G", otherwise If B1:B10 starts with an 4 or 5 then C1 = "R", Otherwise C1 = "F"

Can anybody help me. Hope i've explained it ok.

Thanks
Gavin

 

[GettingThere]

Hi Gavin,

If I understand correctly - I think this is what you're after:

=IF(LEFT(A1,1)="x","G",IF(OR(LEFT(B1,1)="4",LEFT(B1,1)="5")=TRUE,"R","F"))

I notice that in your formula below you're putting A1:A10 - do you really want to say if any cell in that range? The formula I've put above gives just for that row and you'd copy it down for each row you want to check...

Hope that helps - Give me a shout if you need anything else....

A. =D

 

[Shales]

Thats brilliant, thank you.

Had to amend the forumla a little but thats because I didn't explain it that well.

Thank you very much