Excel - IF calculation

I need a formula that will only give a result if there is data entered in all
cells used in that  formula,eg if a=b-c,& b=20,c=10,then a=10,but if b=20 and
c=blank,then I want a=0.I only want a result in "a" if both "b" and "c" have
data entered in them."c" will mostly not have any data entered for some time
after "b" does,and I want no amount to appear in "a" until "c" has an amount
entered into it.
eg if b=0(or blank),c=10,then a=0(not -10),if b=20,c=10,a=10
I am using excel 2003
thanks for any help I can get

  Fred Smith replied to bukti

Try this:
=if(count(b1:c1)<2,0,b1-c1)

Regards,
Fred.

Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 Excel Operating System Windows Vista. When I open Microsoft Word 97 I get a Microsoft Visual Basic error message " Compile error in hidden module: Autoexec" If I click OK the appears to function properly. When I click on Excel 97 shortcut three Windows open namely: Microsoft Visual Basic - PDF Writer.xla (running) PDF Writer.xla-AutoExec (Code) PDF Writer.xla- Registration Database (Code) with a Microsoft Visual Basic error message "compile error: can't find project or library" When I click this fault associated with the Office Programs would be appreciated. Thank you Excel Setup Discussions Microsoft Word (1) Microsoft Office (1) Excel (1) Vista (1) Windows (1) Error (1) I have no idea about

Microsoft Office 2007 Excel Can Microsoft Office 2003 and Microsoft Office Trial Version 2007 co-exist on same computer? Thanks in advance. - - Lavert Bryant Powder if I wanted to keep the older version to which I replied "Yes". Rick keywords: Microsoft, Office, 2007 description: Can Microsoft Office 2003 and Microsoft Office Trial Version 2007 co-exist on same computer Thanks in advance. - - Lavert Bryant Powder

Advance Filter can be based on cell Color in Microsoft Excel Excel In MicroSoft Excel, Advance Filter (Data-> Filter-> Advance Filter) feature can be enhanced. New feature that we apply filter based on Font Color or Highlighted Color. - -- -- -- -- -- -- -- - This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http: / / www.microsoft.com / office / community / en-us / default.mspx?mid = 999c5cf4-7a35-414c-94c9-af63aa7bf0bf&dg = microsoft.public.excel.newusers Excel New Users Discussions Microsoft Excel (1) Excel 2007 (1) NowYou (1) Af63aa7bf0bf (1) In Excel 2007 this is possible

Ms Works spread sheet to Excel 2007 In Vista - -- -- -- -- -- -- -- - This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http: / / www.microsoft.com / office / community / en-us / default.mspx?mid = 9a6295a6-c821-45dd-bb27-4dbe4ae805e1&dg = microsoft.public.excel.newusers Excel New Users Discussions Excel (1) Vista (1) 2007 doesn't seem Ms Works spread sheet to Excel 2007 In Vista - -- -- -- -- -- -- -- - This post is a suggestion for Microsoft, and Microsoft responds to the sugges

Geographic Data Excel I want to create a data map and I need to have Microsoft Map installed. Apparently Microsoft Map was not installed when our IT Department installed Excel (I am running Excel 2003). I believe I ahve to rerun Setup to install Microsoft Map however my IT Department says they can't find Microsoft Map in the Setup file. Can any one help me tell them how to locate Microsoft Map in the Setup file? Excel Charting Discussions Excel (1) Hi, Map was dropped as in xl2003 you will need to buy the standard alone program. Cheers Andy - - Andy Pope, Microsoft MVP - Excel http: / / www.andypope.info keywords: Mapping, Geographic, Data description: I want to create a data map and I need to have Microsoft Map installed. Apparently Microsoft Map was not installed when our IT Department installed Exce