| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
| How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Linear Mode
