In the same Wookbook, I have entered a formula in one spreadsheet, to search for a number or date in another spreadsheet, like this:
=IF('Cal Ven 1'!P44<>"BLANK",'Cal Ven 1'!P44,'Cal Ven 1'!P43)+I...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
Zones:
MS OfficeDate Answered: 03/04/2002 Rating: 6.2 Views: 0
I think this has been asked here before but I'm not sure.
I have a column that is full of formulas down to about row 111.
I have a macro that fills some other cells and does a few things.
Th...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_102...
Zones:
MS OfficeDate Answered: 12/19/1999 Rating: 5.8 Views: 0
I want to make my form so when you click on general_total it works out the formula:-
Private Sub General_Total_Enter()
If [General Test A] And [General Test B] And [General Test C] = Not "" The...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10311844.html
Zones:
MS AccessDate Answered: 03/20/2000 Rating: 6.2 Views: 0
I need a formula in cell A1 (it could be any other cell) that shows document name.
For example:
Document name is 2345.xls, than in A1 should be 2345.
If I change document name, when opened, A1 s...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_103...
Zones:
MS OfficeDate Answered: 04/10/2000 Rating: 6.2 Views: 0
In Lotus, the Tools/Audit menu option "Highlights or produces a report of all formulas, or the relationships of values and formulas in the current file....", according to Lotus Help. Through the ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_200...
Zones:
MS OfficeDate Answered: 12/18/2000 Rating: 9.0 Views: 23
Is there a formula or macro which will allow one to sum the numbers in a column based on the values in either 1 or 2 cells on the same row?
For example, in cell A1 is the value 5, in cell A2 is th...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_200...
Zones:
MS OfficeDate Answered: 02/11/2001 Rating: 8.6 Views: 0
I have a spreadsheet that I use to calculate the cost of moving something.
My cost per unit is $9.17. I want the user to enter the # of units in cell 10B.
I need a formula to calculate the...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_200...
Zones:
MS OfficeDate Answered: 03/01/2001 Rating: 8.2 Views: 0
Here's a formula I'm using in a spreadsheet, but it's ignoring the text that I want it to put in there. Can't you use error messages (#N/A, #NUM!, #VALUE!) within a formula? I know I've seen anot...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
Zones:
MS OfficeDate Answered: 04/18/2001 Rating: 7.4 Views: 0
Hi,
I'd like to know if anyone has a creative suggestion. I have a table that looks like this:
1999 1999 1999 1999 1999 1999
Jan Feb Mar April May June and continues into 2002...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
Zones:
MS OfficeDate Answered: 06/09/2001 Rating: 5.8 Views: 0
I recently had help with a macro that 1st deleted Months 2 thru 12 worksheets, then copied Month 1 to Months 2-12.
The macro did what I asked but there is an unforeseen problem. Other, non-month...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
Zones:
MS OfficeDate Answered: 07/24/2001 Rating: 7.8 Views: 0
