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

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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
0
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
158
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
0