Excel Formular Problem [Solved/Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
213
=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