PDA

View Full Version : Embarrasingly simple Excel question !


TimS
19th Jun 2007, 14:42
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
19th Jun 2007, 15:42
=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
19th Jun 2007, 15:55
That's the one Whirls - thanks.

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

Buggah!

Thanks again


SEO by vBSEO 3.6.1