Embarrasingly simple Excel question !
Thread Starter
Join Date: Nov 2000
Location: Perm any one from 3 !
Posts: 310
Likes: 0
Received 0 Likes
on
0 Posts
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
Join Date: Feb 2003
Location: Propping up bars in the Lands of D H Lawrence and Bishop Bonner
Age: 59
Posts: 5,705
Likes: 0
Received 0 Likes
on
0 Posts
=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