Embarrasingly simple Excel question !

[TimS]

I really should know how to do this (but am obviously going senile).

I want to display a short block of text in one box if a certain numeric value shows in another - simple 'if' formula I assumed but what indicator goes around the text i.e =if(a2=325,BAL,0).

Or am I doing this the wrong way.

Can't find an answer on 'help' so far and don't have my reference books with me.

[Whirlygig]

=IF(A2=325,"BAL",0)

Brackets around the if statement which comprises (ifstatement,then,else) and text must have double inverted commas around it.

Hope this was what you were after.

Cheers

Whirls

[TimS]

That's the one Whirls - thanks.

Tried everything but the " !!!! Which, of course is the obvious one.

Buggah!

Thanks again