intercept and slope functions
I'm using Vista and Office 2007. I have formulas using intercept and slope
calcs, but they are now coming up as DIV/0. Thre are no "0"s in the list and
I have the addins activate. What am I missing Tag: Making formula results not visible in a cell Tag: 505783
gathering multiple spreadsheets into one
I have 2 worksheets (2 individual XLS files) that I need to bring together
into a single worksheet.
The first column of each spreadsheet is the "persons" ID number.
I want to append the in worksheet 1 with the data in worksheet 2, based upon
the ID number. The data in worksheet 2 is a mix of text, number, phone
number, etc.
Is there a single formula I can use to bring it all in based upon the ID
numbers in column A?
eg.
WS1 WS2
123|Mark 157|trans|(201)646|2008 Event|Yes
124|Harry 123|mortg|(732)995|2008 Event|No
129|Dave 762|rund|(676)423|2007 Event|Maybe
129|mortg|(212)123|2008 - Trip|Yes
124|party|(919)222|2006 - Trip|No
DESIRED RESULT IN WS1
123|Mark|mortg|(732)995|2008 Event|No
124|Harry|party|(919)222|2006 - Trip|No
129|Dave |mortg|(212)123|2008 - Trip|Yes Tag: Making formula results not visible in a cell Tag: 505773
VALIDATION
while playing around, i did something that seems to have disabled my
"data-validation" drop down list in a range. it seems to have something to do
with auto fill. can anyone perhaps help? Tag: Making formula results not visible in a cell Tag: 505766
Cell insertion if values not matching
Thanks in advance for your help!
I have created a spreadsheet to inventory equipment that have GPS units -
I need help in working through some formatting or Macro, ???
I have placed my master equipment listing in Row B
The exported GPS listing Equipment number in Row C
If they match - Row A has conditional formatting to indicate color Green &
'Verified'
What I need is if they do not match -
If row C > row B, insert blank cells in row on columns C,D, & E and shift
cells down to continue the verification process thru the entire 400 piece
listing.
--
Thanks!
Susan Tag: Making formula results not visible in a cell Tag: 505765
IF Function with ISBLANK
Hello,
I'm hoping someone can figure this out. I am trying to add a value to
B1 using the following:
I started out with =IF(ISBLANK(A1),"",8)
A1 will either be blank or contain a date. As an example I want to
change the above so that if I enter in A1 the date of May-7x the the
value in B1 will return a 4. And if I enter the date of May-7z into
A1 then the value returned in B1 should be 8.
So to summarize, B1 should either be blank, contain a 4 or contain an
8. I think the key is that I need to define a wild card (if possible)
to look for either the 'x' at the end of the date to bring back '4' or
a 'z' at the end of the date to bring back an '8'.
Its a bit confusing to explain, hopefully you can understand.
-Thanks Tag: Making formula results not visible in a cell Tag: 505763
lookup/match mult values
SHEET 1: (lookup Values)
COL A - House #
COL B - Group Name
SHEET 2: (lookup Vectors & Array)
COL C - House #
COL D - Group Name
COL E - Amount (RETURN VALUE)
I want to use a lookup formula of some sort to match the row from Sheet 1
using information from Columns A&B.
Then match it with the rows in Sheet 2 that have the EXACT matching
information in Columns C&D, and then return the value from Column E.
For example,
Sheet 1:
COL A COL B
1486 Yellow2
Sheet 2:
COL C COL D COL E
1486 Blue1 97
1486 Yellow2 26
So I would like the return value to be 26 (not 97) Tag: Making formula results not visible in a cell Tag: 505762
Formula problem
I have the following formula to calculate a persons age based on todays date
in one column and their DOB in another, but I need to modify the formula so
if no DOB is listed, the formula returns a blank. Currently a blank in the
DOB column calculates to 108.
=DATEDIF(M2,K2,"Y")
I need to add something to this so I get a blank, not 108.
HELP!!!
Thanks Tag: Making formula results not visible in a cell Tag: 505757
Reference sheets
I am setting up a spreadsheet that I need help with. In the first column, I
want them to choose their name from a list of about 80 names. In the 2nd
column, I want them to choose their role from a list of 6 roles. In the next
3 columns, I want them to choose their mentors, but the list of choices is
determinant on what they chose for their role in the 2nd column.
Can anyone please help with how to set this entire spreadsheet up?
Thank You! Tag: Making formula results not visible in a cell Tag: 505755
new cell for each day
I am trying to use the date cell in one workbook to determine what cell of
another workbook that I pull. so if today is the 6 then it will pull cell
g12 in
another workbook.
=+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9))
--
Libby Tag: Making formula results not visible in a cell Tag: 505752
problem summing columns with dates
I have a table where I am summing columns containing date information. The
table looks like:
E F G
years months days
1 2 9
0 5 6
29 0 0
0 6 2
total 32 2 0
the years, months, days information is found by the following formulas that
Pete_UK showed me last week (thanks again Pete the formulas they work great).
FYI (A9 is beginning date mm/dd/yyyy and C9 is ending date mm/dd/yyyy
years -
=DATEDIF(A9,C9,"Y")+IF(DATEDIF(A9,C9,"YM")+IF(DATEDIF(A9,C9,"MD")>=14,1,0)>10,1,0)
months -
=IF(DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"md")>=14,1,0)>=9,0,DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"md")>=14,1,0))
days - =IF(DATEDIF(A9,C9,"md")>=14,0,DATEDIF(A9,C9,"MD"))
The problem I am now encountering is this: When the days column >=15 days I
am to add 1 to months and then return 0 in 'days total' or >=45 days then add
2 and then return 0 in 'days total', else return sum total of column C; then
when the months column is >=9 then add 1 to year and return 0 unless the
total months is between 13 & 16 then you would add 1 to year and return the
difference between the total months-12 (you would then repeat this process
for each multiple of 12 months (add 2 years and then return months; if total
months are between 9 and 12 you return 0 to months total) or if total months
is < 8 then return sum of months column
I have shown, in the example above, what the total should look lilke but
have been unable to get it. This really has me stuck. Thanks for any help
LAMP Tag: Making formula results not visible in a cell Tag: 505746
Formula problem
I am having problems coming up with a formula
Here is my scenario
If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
Column B Tag: Making formula results not visible in a cell Tag: 505740
If Question
I am looking for a formula in ColC that will return TRUE is the right
character in COLA is 0 (zero).
ColA ColC
123 FALSE
120 TRUE
Thank You in Advance. Tag: Making formula results not visible in a cell Tag: 505728
new cell each day
How do I create a formula to pick a new cell each day of the month. If today
is the 6 and I want to reference cell g12 and on the 7 I want to reference
cell g13 and so on.
--
Libby Tag: Making formula results not visible in a cell Tag: 505727
Calculated Fields and Pivot Tables
Assume that I have a Pivot Table that looks as follows:
Jan-08 Feb-08 Mar-08 Apr-08 Total
Client 1 10,000 11,000 8,000 14,000 43,000
Client 2 0 2,000 500 100 2,600
Client 3 5,000 4,500 0 0 9,500
Client 4 15,000 15,000 13,000 8,000 51,000
Client 5 3,500 5,000 7,500 9,000 25,000
33,500 37,500 29,000 31,100 131,100
I would like to have the Pivot table to produce results like this:
Jan-08 Feb-08 Mar-08 Apr-08 Total
Client 1 10,000 11,000 8,000 14,000 43,000
% of Prior
Month 110.00% 72.73% 175.00%
% of Current
Month 29.33% 27.59% 45.02%
Client 2 0 2,000 500 100 2,600
% of Prior
Month #DIV/0! 25.00% 20.00%
% of Current
Month 5.33% 1.72% 0.32%
Client 3 5,000 4,500 0 0 9,500
% of Prior
Month 90.00% 0.00% #DIV/0!
% of Current
Month 12.00% 0.00% 0.00%
Client 4 15,000 15,000 13,000 8,000 51,000
% of Prior
Month 100.00% 86.67% 61.54%
% of Current
Month 40.00% 44.83% 25.72%
Client 5 3,500 5,000 7,500 9,000 25,000
% of Prior
Month 142.86% 150.00% 120.00%
% of Current
Month 13.33% 25.86% 28.94%
33,500 37,500 29,000 31,100 131,100
For Client 2 for Feb-08 the % of Prior Month should be 100%. For Client 3
for Apr-08 the % of Prior Month should be 0%.
I don't know how to get the new rows to calculate inside the pivot table. I
think that Calculated Fields would be used but I can't seem to figure how to
do it after reading some books that I have.
Any help would be greatly appreciated. Tag: Making formula results not visible in a cell Tag: 505716
SUMIF Criteria
I'm trying to use the SUMIF function with criteria that value must be >30 and
<=60. How would I code that with this function? Tag: Making formula results not visible in a cell Tag: 505715
Single Quote use in cell reference
I am trying to decifer a spreadsheet prepared by someone who has left the
company. They used the following cell reference, which appears to reference
an outside spreadsheet without using the full spreadsheet name, ='AR
''06'!G414.
What do the two separate items in single quotes do. I can't figure out what
'AR ''06' is?
Any thoughts are greatly appreciated.
Thank You, Tag: Making formula results not visible in a cell Tag: 505695
Sum If Help
I need to have a total cell for a large spreadsheet I'm working on (150+lines
of data). I need to put in a formula that will add the amount in Column B if
the word in the Column A says "Retail".
Example:
A B
Retail 10,950
Storage 6,500
Retail 5,000
Retail 4,000
Storage 3,500
Total Retail Amount
Total Storage Amount
Relatively new to Excel, so any help would be greatly appreciated!!! Tag: Making formula results not visible in a cell Tag: 505693
Formula Halp - If or Lookup
I am not sure how to get the results I am looking for, and if it is better to
use an if statement or a lookup funtcion (which I have never used before).
Data Information:
Column "AO" contains one of 5 names
Based on looking at these names, I want a formula that puts one of 5
corresponding intials in column BA.
Any formula suggestions would be truly appreciated!! Tag: Making formula results not visible in a cell Tag: 505691
conditional formatting
I am trying to import categorical data into a spreadsheet. I need the
categorical data to import as numerical values (i.e. white = 1, black = 2,
hispanic = 3, etc.)
Is there a way to do this using conditional formatting? If not, please offer
a different suggestion.
Thanks! Tag: Making formula results not visible in a cell Tag: 505690
To count how many are in a certain age group
Hi! I'm looking for at forumla to count how many are in a certain age group.
I have a list of people and their ages and would like to know how many are in
the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on
--
LEG Tag: Making formula results not visible in a cell Tag: 505689
How do I move numbers with formulas behind to new workbook?
I'm working with excel 2003. I received a spread sheet via email. There
are several colums adding up to a total. I want to do is take the total
column and the vendor name and move them to a new workbook. when I copy and
paste, the information will not transfer because of the related formulas.
Help Please Tag: Making formula results not visible in a cell Tag: 505688
Condiitonal formatting-colored cell
I would like a cell to turn yellow if I start a sentence with an *, if there
is no *, then no color.
How would I phrase this in the conditional formatting option? Tag: Making formula results not visible in a cell Tag: 505687
Find next value
I am trying to return a value in cell B3 from E5:E40 using the SUMIF formula.
In cell B4 I want to return the next value in E5:E40 that meet the same
criteria. Right now it is adding them together.
Thanks
Bobby Tag: Making formula results not visible in a cell Tag: 505684
some worksheet columns don't update formula calculations
I have a worksheet where my sheet 1 is taking numbers from sheet 2 and 3 and
then using those numbers from sheet 2 and 3 to make calculations sum formulas
that I've inserted.
Some of the columns work fine, when I make a change to a cell 4, column 4 in
sheet 2, I notice the numbres change in sheet 1 and reflect the changes I
made to the cell in sheet 2, but some other columns don't work in sheet 2.
For example when I make a change to cell 4 in column 5, the numbers on sheet
1 don't reflect the change I made. The formula's on sheet 1 are correct and
are pointing to sheet 2. The only way the calculation works on sheet 1, is
that if I click on sheet 1 where the cell pointing to cell 4 in column 5 for
sheet 2 is and then hit enter. Any idea's why that is happening on certain
columns but not others? Tag: Making formula results not visible in a cell Tag: 505682
help with formula -
Hi,
Legend:
a1 b1
TX 8.25%
MA 5%
-------------
c1 d1
$100 MA
$200 TX
$300 EU
--------------
How do I obtain a formula, perhaps vlookup, that if, column (D) matches with
ledgen column (A), then take value column (c) time the percentage column (B),
otherwise, N/A?
Thanks
Soth Tag: Making formula results not visible in a cell Tag: 505681
text for numbers
I am using SUMIF for returning number values that meet certain criteria.
Now I want to return text, instead of numbers, that meet certain criteria
and am having trouble. Also I do not want a zero to return where there is no
value.
Thanks
Bobby Tag: Making formula results not visible in a cell Tag: 505680
Accidental Currency Converted
Hmm, strange one. I opened a file recently and all my $ changed to
DM. As I opened other files, same thing. Our IT department just put
SAP's Business Explorer on my desktop and I am wondering (being a
German company and the fact that it is coming up at Deutche Marks)
that the SAP install reset some setting.
Anyway, I checked via the Control Panel, and all my Regional Settings
look fine (e.g. US). I can't find (at least in Excel 2007) anywhere
that I can convert everything back to $..except manually - and this
would go for every spreadsheet I use.
Any thoughts?
Thanks.
v/r
PAZ Tag: Making formula results not visible in a cell Tag: 505679
Duplicate entries in single column w/o sorting?
I am trying to find duplicate entries (text) in a single column without
sorting. The column is several hundred rows in length. Can someone help?
--
Regards, SColdiron Tag: Making formula results not visible in a cell Tag: 505673
vlookup on multiple values
I have the following data in 3 columns
A B C
TOP BULB 1
TOP SCREW 5
TOP LIGHT 1
TOP LAMP 1
TOP PAPER 1
BOTTOM BULB 5
BOTTOM SCREW 4
BOTTOM LIGHT 2
BOTTOM LAMP 8
BOTTOM PAPER 7
I want to be able to first match against the value in column a then find the
match in column b once it finds both match then return the result of column
3. Tag: Making formula results not visible in a cell Tag: 505670
Aging reports
I need to report on aging of invoices based on when the service was incurred
vs. when it was actually paid. Tag: Making formula results not visible in a cell Tag: 505666
Getting Count Formula Working if Column has both number and text
Hi
Currently I am trying to get Count of Certain numbers in column which has
numbers as well as text. I have data which is very uneven e.g 4 number then
followed by text "Total" then again 5 numbers followed by text "Total" I need
to have Count of numbers field for each category which ends with text "Total".
As number of entries are not same everytime how can I use count formula?? or
is there any other better way of finding out Counts of each category.
--
Nikhil Joshi
Pune India Tag: Making formula results not visible in a cell Tag: 505661
If results for multiple cells
I am collecting data for a salt bath temperature comparison. There are three
readings from the salt bath (controller, high and low) and 3 readings from a
test sensor. The test sensor readings are subtracted from the bath readings
and the results are listed in cells J4, K4 and L4. I am allowed +/- 2
degrees difference for the test to be acceptable. In cell M4, I want the
results to show Accept or Reject. What formula would I use to show Accept
for -2 to +2 in all of cells J4 thru L4 and Reject for any value exceeding -2
to +2 in any one of the cells J4 thru L4? Tag: Making formula results not visible in a cell Tag: 505658
Arbitrary Lookups - return ALL found values
Hello, for long time now I'm searching a way in excel to solve following:
Data I have:
Name Score
Annie 11
Beth 22
Cathy 33
Dana 44
Annie 55
Beth 66
Annie 77
Beth 88
Cathy 99
Data I want to produce:
Name Score
Annie 11|55|77
Beth 22|66
Cathy 33|99
Dana 44
The character "|" is just a example of separator it can be any other
meaningfull characted. Tag: Making formula results not visible in a cell Tag: 505654
Goal Seek Goes Haywire
I am using Goak Seek in a macro to calculate the interest rate needed on a
cash flow to hit a known amount. Below shows the problem I'm having in some
of the 60 columns I'm using. Evetually this will be 121 columns.
In each year I need to find the ROR such that the sum of each year's Cash
Flow at the ROR to the power of the number of years remaining equals the
Target Amount. In the first row is the "To Value" AKA the "Set Cell". The
second row is the "guess" for the rate. Goal Seek will be using that as the
"By Changing Cell". The last number at the bottom of the colum is the sum of
the Cash Flow at Interest. Each cash flow in a column is being calculated as:
Cash Flow * ((1 + Current Year) ^ Remaining Years
In the three examples below, the first and third are fine. The question is
why does the middle one go haywire? Is there a better method than Goal Seek
for this?
Year 17 `````````Year 18 Year 19
1,171,483.02 1,198,769.86 1,230,301.72 <Target Amount
3.0962873% -222.3366976% 4.9282072% <Goal Seek's Answer
17347.29485 389154.3337 25766.36287
16826.30413 -318101.0616 24556.18329
16320.96031 260020.965 23402.84271
15830.79346 -212545.3524 22303.67157
15355.34778 173738.017 21256.12566
14894.18114 -142016.2718 20257.78028
14446.8647 116086.403 19306.3246
14012.9825 -94890.9079 18399.55635
13592.13107 77565.36655 17535.37666
13183.91906 -63403.18815 16711.78526
5286.023088 21423.07939 6583.519821
4478.854835 -15296.99417 5480.836563
3668.8139 10559.68761 4411.195657
2858.200063 -6932.729974 3376.556616
2005.303756 4099.001722 2327.621458
1158.544046 -1995.706888 1321.281967
216.5022034 314.2916191 242.6029359
1171483.021 990.9272504 -891.8042216
1198769.86 -2046.10004
1230301.72
<sum of column Tag: Making formula results not visible in a cell Tag: 505649
SUMPRODUCT or another function???
Hi All,
I am at my wits ends trying to do some excel magic so after days
trying to figure this out myself I have turned to here in
desperation.. I am hoping someone can tell me if I am on the right
track or point me in the right direction.
What I have is a large amount of raw data split across a number of
worksheets. It clinical data so I can't post here, but essentially
the first sheet contains a doctors name and a request number plus
other misc data.. The second , third, fourth etc worksheets contains
specific information about a type of examination.. These subsequent
worksheets do not contain the doctors name, but only contain the
request number and patient related details..
I want to count how many times a a doctor has performed examination X
and examination Y and so on by matching the request numbers in the
first sheet to the request numbers in the second,third, fourth etc
worksheet.. I figured this would be possible by using sumproduct but
have had absolutely no luck getting this to work..
So as an example I have the following data in sheet 1 and sheet 2
Sheet 1
A B
Paul 1
Fred 2
Joe 3
Michael 4
Paul 5
Paul 6
Paul 7
Paul 8
Fred 9
Joe 10
Michael 11
Joe 12
Sheet 2
Patient data 3
Patient data 5
Patient data 6
Patient data 7
Patient data 10
Patient data 12
I have used the sumproduct function as follows
=SUMPRODUCT((A:A="Paul")*(B:B=Sheet2!B:B)) and I get 0 as an answer
which I don't understand.. In the first worksheet i figured it would
check that the first column had "Paul" in it and then check whether
entries in column b matched between both sheets...
Is sumproduct the right function to use considering the size/number of
rows in each sheet can differ dramatically? or is there another
function that give me the answers I want?
Thanks in advance
Paul Tag: Making formula results not visible in a cell Tag: 505647
using multiple sheets from a workbook in a formula
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into
the formula box then clicked onto the other worksheet and selected the cell,
but that doesnt seem to be working, any ideas anyone?
Thanks. Tag: Making formula results not visible in a cell Tag: 505643
Percentages and whole numbers
Does anyone know how to convert numbers that get imported as percentages
converted to whole numbers?
Ex. 100% to 100, 80% to 80
Thansk for any help. Tag: Making formula results not visible in a cell Tag: 505636
Need formula like ISBLANK that returns "no value" even if there is a
In a cell, I often want to reference another cell and want to return
"No value" or have it remain Blank, but the cell that I am referencing
has a formula, so ISBLANK does not interpret that the referenced Cell
is Blank. What formula can I use to return no value or leave the cell
blank even though the referenced cell has a formula?
Jim,
Denver Tag: Making formula results not visible in a cell Tag: 505635
Referen to cell on other sheet not working
Hi,
I received this strange problem:
On sheet 02-E14-4 in an Excel fie, the cell M23 contains the value 0,500.
On another sheet (Récap2008) cell I83 contains this formula:
='02-E14-4'!M$23. BUT: the value it shows is 0,250 instead of 0,500.
Only when I re-enter the value in cell M23 it shows the correct value, or
when I re-enter the formula in cell I83. Any idea why this happens? And how
to find a solution???
Thanks a lot in advance, any help will be really appreciated!
Pieter Tag: Making formula results not visible in a cell Tag: 505632
Advanced Criterea in Formulas
I'm trying to figure out the best way to use advanced criterea in formulas.
Here's my example:
Date Account Amount
1/1/08 account a -$5
2/2/08 account b $10
3/3/08 account a -$4
4/3/08 account c $12
...and so on for all my financial transactions
my second worksheet is set up as follows
Account Jan 08 Feb 08 Mar 08 Apr 08
account a
account b
account c
Now in each of the columns for the second worksheet I want to enter a
formula that will calculate the total of all transactions for the specific
account during the specific month. I thought maybe the sumif function could
do this, but I can't figure out how to specify multiple criterea in that
function. All I can figure is that I have to set up a seperate criterea
table for each cell to reference (which seems like a lot of work if I have 10
different accounts and I'm looking for monthly calculations over the past 5
years! Isn't there a way to enter different multiple criterea for different
formulas without needing to create multiple criterea tables? Tag: Making formula results not visible in a cell Tag: 505628
can excel alert you when a number is less than a particular value
I am making a spreadshett to control stock and I want a message to come up
and alert the user when the remaining stock of an item is less than 15,
anyone know how to do this? Tag: Making formula results not visible in a cell Tag: 505626
Calulate a value when date is in a range.
Hi there,
Please can you help! I am trying to calculate from a list of dates,
which calender Period the date falls into.
I have a table in excel with period number in first col1, period start
date in col2, period end date in col3.
I then have a list of about 500 dates and want to put in the column
next to each date which period the date equals.
I've tried nested if and offset functions but cannot figure it out!!
If anyone can help, we would be most greatful.
Meg Tag: Making formula results not visible in a cell Tag: 505624
Calulate a value when date is in a range.
Hi there,
Please can you help! I am trying to calculate from a list of dates,
which calender Period the date falls into.
I have a table in excel with period number in first col1, period start
date in col2, period end date in col3.
I then have a list of about 500 dates and want to put in the column
next to each date which period the date equals.
I've tried nested if and offset functions but cannot figure it out!!
If anyone can help, we would be most greatful.
Meg Tag: Making formula results not visible in a cell Tag: 505623
Insert sheet linkage
In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.
I tried a few things buy didn't work, hope someone can give me a solution.
Thank you Tag: Making formula results not visible in a cell Tag: 505622
Function to insert current filename into worksheet?
Hi
I'd like to know if there is a function that I can use to put the current
fileame into a cell in my worksheet?
Thanks Tag: Making formula results not visible in a cell Tag: 505621
Conditonal Formatting
Can someone advise me how to change the cell color when date is input
I had the following advise formula for text and number but it does not work
with date format
Format ==> Conditional Formatting
Formula is: =istext(A1) Tag: Making formula results not visible in a cell Tag: 505615
How to set Auto-Change letters into Uppercases for Data entry in E
Hi,
I need help here.
Here is the scenario.
When I type alphabets in lower cases at each cell, I need the cell to
auto-change the alphabets to upper cases. I do not want to use the Caps Lock
button from the keyboard.
Help...
--
Thank you,
Cpviv Tag: Making formula results not visible in a cell Tag: 505610
Which function do I use?
I have long lists of orders which I can easily sort but what I would like to
do next is choose a column (e.g. order number) and have just the first
occurrence of each number returned.
Everyone here seems to think that they know how to do this but no one has
got as far as proving it yet.
Cheers
--
I started with nothing and I still have most of it left Tag: Making formula results not visible in a cell Tag: 505603
How to change color in cell when there is input
Example
Col A is fill Green, cell format is general - Color disappear when text is
enter
Col B is fill Blue, cell format is currency - Color disappear when number is
enter Tag: Making formula results not visible in a cell Tag: 505602
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2
I have done this before but it was a long time ago. e.g.
Apple Banana Apple Banana Apple Banana
Banana Apple Banana Apple Banana Apple
Banana Banana Banana Banana Banana Banana
Apple Apple Apple Apple Apple Apple
Apple Apple Banana Banana Apple Apple
Banana Banana Apple Apple Banana Banana
and so on up to 36 selections=6 rows of 6 Tag: Making formula results not visible in a cell Tag: 505600
In my "total" column I don't want the results of the SUM to show up if there
is not an entry in the cell to the left of the SUM cell.
--
MPS
Re: Making formula results not visible in a cell by David
David
Wed May 07 16:07:15 CDT 2008
=IF(A101="","",SUM(B1:B100))
--
David Biddulph
"mp smith" <mpsmith@discussions.microsoft.com> wrote in message
news:DBF1B732-11E4-4C01-B016-E401D9C31A63@microsoft.com...
> In my "total" column I don't want the results of the SUM to show up if
> there
> is not an entry in the cell to the left of the SUM cell.
> --
> MPS
Re: Making formula results not visible in a cell by T
T
Wed May 07 16:08:25 CDT 2008
Try something like this:
=IF(A10="","",SUM(.....))
--
Biff
Microsoft Excel MVP
"mp smith" <mpsmith@discussions.microsoft.com> wrote in message
news:DBF1B732-11E4-4C01-B016-E401D9C31A63@microsoft.com...
> In my "total" column I don't want the results of the SUM to show up if
> there
> is not an entry in the cell to the left of the SUM cell.
> --
> MPS