|
It's pretty straight forward. If a certain cell, such as A1, is the value "0", I would like A2 to contain an arbitrary value. Otherwise, I would like the user to be able to enter their own value. The first part is easy:
A2=IF(A1 = "0", "value", "")
However...
Started by Rosarch on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Something like this #.0;#.0;"Value" then copy the value from A1 to A2 and use the custom number format.
|
|
As a state of the seats of Excel ...
There are plural seats.
The first seat name is "list"
The other seats get possible to move in hyperlink from the list sheet.
the seat name are "example1", the "example2" .
Please teach VBA setting hyperlink to "list...
Started by ffffff on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Else ws.Hyperlinks.Add Anchor:=ws.Range("A1"), Address:="", _ SubAddress:="List!....
"How can I use VBA to create a hyperlink in cell A1 on each sheet of a workbook to link back = "List" Then 'Do nothing for the list sheet.
Is as follows.
|
|
Originally Posted by A1NUTRIENTS We didnt want A1 straight affiliated with Mj, google searchs for A1 were all weed related,
GoDs at Avalon everyday and A1Nutrients wil have its own forum. Scwhoop will handle all the Mj stuff GoD related and A1 will handle...
Started by Emithsuk on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at thcfarmer):
Agreed, we will be on many garden sites, and there are still plenty of A1 threads on here with people who test for us, and there will be a A1 Forum under Nutrients/Fertilizers, So any and all Q's can and A1 will be on T.V this spring....
|
Ask your Facebook Friends
|
Given a Row and Column (As Long), how can you determine the spreadsheet notation using VBA in Excel (2007):
e.g.:
(R, C) = (1, 1) -> "A1" (R, C) = (2, 1) -> "A2" (R, C) = (2, 2) -> "B2"
Thus if you had a function:
Function CellRef(R As Long, ...
Started by Cade Roux on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Maybe this is what you are looking for?
Column Numbers to Letters
Column Letters to Numbers
The good stuff is in the comments .
|
|
Does anyone from Lenovo know when a new firmware will be released?
I am specifically looking for a fix to the 3 buttons at the bottom of the tablet where the illumination turns off straight away so that you can't even see the buttons. Would like to see...
Started by mundo on
, 7 posts
by 5 people.
Answer Snippets (Read the full thread at lenovo):
After using the A1 for about a month, I am.
It's gotten great reviews on Amazon.
I recently bought the Moko case for the A1 Viewsonic G-Tablet.
Solution to this "hidden/unlit" icon problem is this...
|
|
Whats up farmers?
Before I start I gotta give a huge shout out to GOD and the crew at AWC. Without them I wouldn't have some of these killer strains, nutes, or soil. And a super special thanks to GOD for allowing me to run his nute line and run his soil...
Started by treebark1950 on
, 10 posts
by 4 people.
Answer Snippets (Read the full thread at thcfarmer):
I recently got some a1 nutes.
When I don't have enough room to mother them and flower them all, lol .
|
|
Yah or nay? Cosmetically speaking what do you all think of FCS on a Colt 1991 A1 with the GI pattern serations?
Started by rushca01 on
, 15 posts
by 15 people.
Answer Snippets (Read the full thread at 1911forum):
Since you asked opinions, I can't stand them on 1911 type .
100% personal preference.
On 1991 A1 Ugh...
|
|
On Thu, 22 Jan 2009 10:31:01 -0800, DSSSS <DSSSS@discussions.microsoft.com
Can someone give me a forumla that will tell me what the percentage of a
total is in the earlier cell.
Eg. if A1 = 10, C1 = 10, E1 = 10
Total G1 = A1+C1+E1
What % of E...
Started by DSSSS on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
How do I show the difference as a percentage in C1?
A:
As a percentage of A1: =....
How do I get C1 to show B1 as a percentage of A1?
A:
Formula in C1: =B1/A1, Format as %
Q:
I have A1 and B1.
Questions:
Q:
I have A1 and B1.
|
|
A1 Drawing Board. Parallel Motion and Dimension. 920mm x 650mm.
This is a professional board, very nice. Quite compact as A1 Drawing boards go.
Sorry to see the old lady go. It is a Weymouth and they don't come any better.
Started by sooperchamp on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at jumbletown):
|
|
Sharpening Fallkniven A1 convex edge? Hey guys,
As the title says, how do I sharpen a convex edge?
Will it matter if I just sharpen it like a generic blade or will it chip out easier etc?
Also, has anyone ever used the heinnie sharpening service,(was ...
Started by Maxamus on
, 11 posts
by 6 people.
Answer Snippets (Read the full thread at britishblades):
Re: Sharpening Fallkniven A1 convex edge? there is only one bloke you want to use for sharpning/lucky_...ow/with/564050 Re: Sharpening Fallkniven A1 convex edge? Thanks! Re: Sharpening Fallkniven A1 member of the BBCTS Re: Sharpening....
|
