Search : in
By :

Excel Formular Problem

Last answer on Jun 19, 2009 6:12:20 am BST Funky Town, on Jun 18, 2009 4:13:01 pm BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Excel Formular Problem » in :
Spreadsheets - The Excel Interface Show Excel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Download Excel Viewer Show
Import contacts from Excel to Outlook Show Import contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download Free Excel/Xls to Pdf Converter Show
Download Excel Password Recovery Master Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
Ask your question Reply

1

venkat1926, on Jun 19, 2009 2:18:13 am BST

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

   
Reply to venkat1926

2

 mubashir aziz, on Jun 19, 2009 6:12:20 am BST

=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

   
Reply to mubashir aziz
Ask your question Reply
They need your help