Excel Formular Problem
Solved/Closed
Funky Town
-
18 Jun 2009 à 11:13
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 19 Jun 2009 à 01:12
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 19 Jun 2009 à 01:12
Related:
- Excel Formular Problem
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
18 Jun 2009 à 21:18
18 Jun 2009 à 21:18
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 12 April 2009
Status
Member
Last seen
16 February 2010
166
19 Jun 2009 à 01:12
19 Jun 2009 à 01:12
=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
