IF Formula

[Frazzfreeman]

Hi everyone!

I am after an IF formula for the following example:

If the word 'BER' is placed in to Sheet 1 Cell A1 then i need '£0' to go into Sheet 1 Cell B1

hope this example makes sense, thanx all!!!!

Frazzfreeman

[Conor]

place into cell B1

=IF(a1="BER","L0","")

Not sure how to represent that sterling symbol. I used L instead.