ExcelBanter - help with column text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help with column text (https://www.excelbanter.com/excel-discussion-misc-queries/243735-help-column-text.html)

Please help

help with column text

I got the one function but I need to combine these two function in one.
IF A110 than B2=tim and
IF A1<10 than B2= Bllanko

Eduardo

help with column text

Hi.
if(A110,"Tim",Bllanko")

if this helps please click yes thanks

"Please help" wrote:

I got the one function but I need to combine these two function in one.
IF A110 than B2=tim and
IF A1<10 than B2= Bllanko

Jacob Skaria

help with column text

In cell B2
=IF(A1,IF(A110,"Tim","Bllanko"),"")

If this post helps click Yes
---------------
Jacob Skaria

"Eduardo" wrote:

Hi.
if(A110,"Tim",Bllanko")

if this helps please click yes thanks

"Please help" wrote:

I got the one function but I need to combine these two function in one.
IF A110 than B2=tim and
IF A1<10 than B2= Bllanko

David Biddulph[_2_]

help with column text

=IF(A110,"tim",IF(A1<10,"Bllanko","A1=10 so result undefined"))
--
David Biddulph

"Please help" wrote in message
...

I got the one function but I need to combine these two function in one.
IF A110 than B2=tim and
IF A1<10 than B2= Bllanko

All times are GMT +1. The time now is 04:38 AM.