Using If Function

[Mac0707]

Hi, I'm sure this is very straight forward?
How do I use the 'If' function to return a value in one cell depending on the text in another cell?
So for example; If A1=London then A5 is returned as 100
Many thanks for any guidance.

[sgstevenlow]

A5 cell

=IF(A1="London",100,"")

[PaulM100]

In A5: =If(A1="London", 100,"whatever you want as second criteria")

[Mac0707]

Thanks so much! And if i need to extend that function to add an alternative... eg If A1 = Birmingham then =200, how would I incorporate that as well?

[sgstevenlow]

=IF(A1="London",100,IF(A1="Birmingham",200,""))

[JohnTopley]

=IF(A1="London",100,IF(A1="Birmingham",200,""))

If there are many options then a "lookup" function will be better

[Mac0707]

Brilliant! Thanks