PPRuNe Forums - View Single Post - Embarrasingly simple Excel question !
View Single Post
Old 19th Jun 2007, 13:42
  #1 (permalink)  
TimS
 
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.
TimS is offline