# Excel Formular Problem

Solved/Closed
Funky Town - Jun 18, 2009 at 11:13 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 19, 2009 at 01:12 AM
Hello,

=IF(B2=1,"Entertainment","")

I have this formular which when i type a value into one colume it will display text in another and the end of this formular then obviously displays nothing, when no enter is entered. What i want to do now is add something into this formular for the nxt pending cell to display another text.

For example

=IF(B2=1,"Entertainment","")IF{C2=1,"Sport","") - This formula is coming up as an error, so does anyone have any suggestions. thanks
Related:

## 2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 18, 2009 at 09:18 PM
what do you want to do?

Suppose the formula is parked in cells d2
if B2=1 then d2 will be
entertainment whatever c2 be.

If B2 is not 1 then it finds whether C2 is 1 and if so then d2 will be sports. If c2 is not 1 d2 will be blank.
If B2 is not 1 and c2 is not 1 then also d2 will be blank. in that case the correct formula is

=IF(B2=1,"Entertainment",IF(C2=1,"Sport",""),"")

when you write a formula think a series of logic something like this

b2=1 d2
TRUE entertainment
FALSE check c2=1
TRUE sport
FALSE blank
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jun 19, 2009 at 01:12 AM
`=IF(B2=1,"Entertainment","")IF{C2=1,"Sport","") `

Are you clear about your code ???? Do you want to check B2 & C2 one by one ???? then venkat1926 approach is right. Else me too can't understand what you exactly want and why B & c value impact in one cell ???

------------------------------------------
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan