Embarrasingly simple Excel question !
Thread Starter
Joined: Nov 2000
Posts: 310
Likes: 0
From: Perm any one from 3 !
Embarrasingly simple Excel question !
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.
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.
Hovering AND talking
Joined: Feb 2003
Posts: 5,711
Likes: 1
From: Propping up bars in the Lands of D H Lawrence and Bishop Bonner
=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
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
