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. |
=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 |
That's the one Whirls - thanks.
Tried everything but the " !!!! Which, of course is the obvious one. Buggah! Thanks again |
All times are GMT. The time now is 23:54. |
Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.