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
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 19, 2009 at 01:12 AM
Related:
- Excel Formular Problem
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
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
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
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
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
