|
|
=NOW() from changing by
Richard
I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some...
|
|
5 |
66 |
|
|
=PRODUCT by
billy-bob
i'm trying to generate an automatic form (which will locked down)
within the hiden E columm if have a list of numbers, so when i pick 'p'
(this is a tick mark...
|
|
6 |
86 |
|
|
=PROPER by
Snowcap
Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate...
|
|
1 |
126 |
|
|
=PROPER by
Snowcap
Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate...
|
January 21st, 2005 12:19 AM
by Snowcap
|
2 |
81 |
|
|
=PROPER() by
Mukesh
I want to , I tried using =proper(), but
the result I get is , I want all the capitals to be small,
is it possible?
Please...
|
June 6th, 2009 06:45 AM
by Mukesh
|
2 |
146 |
|
|
=RAND produces decimals not whole numbers by
moosegate
I am a teacher making randomised equation sheets for young children in my
school, along with simultaneous answer sheets for teachers to speed up
marking,...
|
|
9 |
103 |
|
|
|
|
2 |
80 |
|
|
|
|
3 |
108 |
|
|
=SF_Load!A2 by
Jim
Hello,
how would I change this formula (=SF_Load!A2) so it shows a nothing if the
cell it's refeerencing is blank. It currently shows 0.
Thanks
|
|
2 |
110 |
|
|
=Sheet!A1 formula alternative by
RLD
I have 2 sheets.
Sheet 1 contains text data from A1:A200 but not in consecutive order (for
example):
Sheet1
A
1 textone
2 texttwo
3
4 textmisc
5
|
|
2 |
143 |
|
|
=Sheet1!A1 - with a blank entry!!! by
CP
Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0
value on...
|
May 26th, 2009 11:00 PM
by CP
|
2 |
156 |
|
|
|
February 10th, 2007 12:25 AM
by Gatsby
|
0 |
73 |
|
|
=SIMILAR by
Andrew Mackenzie
Is there a way to compare text in two cells to see if they are similar (the
pairs of cells may be similar in different ways e.g. to...
|
September 30th, 2004 01:06 PM
by Jim Rech
|
1 |
102 |
|
|
=SMALL(A1:A10;6) returns #NUM error by
CWatters
I'm trying to use
=SMALL(A1:A10;6)
to find the 6th smallest number in A1:A10 but it returns a #NUM error if
there are only 5 fields in the array containing...
|
|
2 |
97 |
|
|
|
|
6 |
106 |
|
|
=sum #value! error by
TanaMary
I did a spread sheet to track payments and the percentages of those payments
bi-monthly over a 12 month period. There are 6 percentage columns total for...
|
|
9 |
112 |
|
|
=sum not working by
SLP
Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are...
|
November 28th, 2007 09:26 PM
by SLP
|
8 |
89 |
|
|
=SUM problems in totalling figures by
the-chosen-one
Hi There,
Im new here and wonder if u guys can help.....I have excel from office
97 and have found a problem when doing a simple column...
|
|
2 |
101 |
|
|
=SUM Ranges Do Not Update by
Country
I have a Excel 2000 spread sheet, with the following macro to insert a
new row.
Sub InsertRow()
'
' Macro1 Macro
' Macro recorded 4/27/2004
'
'GoTo label,...
|
August 24th, 2004 01:27 AM
by Country
|
2 |
74 |
|
|
|
April 5th, 2006 05:17 PM
by Dave O
|
1 |
85 |