How use value of a cell without turning #VALUE!
Fri, 3 Oct 2008 20:52:01 -0700
Hello I'm John. I'm trying to figure out how to use a specific value of a
cell but results in #VALUE! might be because the answer of a formula in there
(k11) is empty or "0".
I have
"=N12+IF(ISNUMBER($K$11+$K$14)>=TIME(0,1,),IF(F14+F11>=TIME(0,1,),($K14*2)+IF($K11>=TIME(0,1,),(K11)*2)))*D2",
it is j ...
|
Conditional Formula Based On A Check Box
Fri, 3 Oct 2008 22:15:14 +0100
Hi all
Is there a way to set a conditional formula based on a check box
created thru the developer tool box
I would like to creat a work sheet that has ( 6 ) check boxes
When the check box is checked it call for a formula set
When it is unchecked it calls for a different formula set
Each formula set woul ...
|
Setting Parameters for SUMPRODUCT Results
Fri, 3 Oct 2008 17:58:01 -0700
I am working on a spreadsheet with SUMPRODUCT results that have set parameters.
The problem I am to solve says:
A factory builds TVs, stereos, and speakers. There are five types of parts:
chassis, picture tubes, speaker cones, power supplies, and electronics
units. A TV earns $75 gross profit, a stereo ea ...
|
Multiple Spreadsheet,Not sure what to use? Vlookup works for first
Fri, 3 Oct 2008 16:44:01 -0700
I have a excel problem with a formula for a spreadsheet, basically I am
trying to combine two accounting spreadsheets. Lets call them spreadsheet A &
B. All my values are in spreadsheet A and this contains four columns. see
below
Code Description Division Amount
1 ...
|
Row??
Fri, 3 Oct 2008 15:43:01 -0700
I have a Row# listed in a cell and a known column. How can I combine the two?
A1 contains the row# with B being the known column.
Result of the formula woulld be 10
a b c
1 4
2
3
4 10
5
Hope this make sense.
Thanks
...
|
credit card payoff worksheet
Fri, 3 Oct 2008 14:38:01 -0700
...
|
Naming work sheet the name as sub-routine that creates it
Fri, 3 Oct 2008 14:02:35 -0700
I have a macro that I'm trying to create several work sheets, and then put
information retrieved from a SQL database. I would like the name of each
worksheet to be the same as the sub routine that created it. Is this
possible through the code --
sub myworksheet
worksheets.add
worksheets.name(x) where x ...
|
|
|
If ID # on one sheet isn't found on another...
Fri, 3 Oct 2008 13:50:08 -0700
I have two differnt source files for employees on two different tabs. Both
tabs have their ID #:
On sheet A it's in the B column.
B C
123 Sam
On sheet B it's on the G columm.
G H
(Sam's ID & name are not on Sheet B)
The row locations are different, me ...
|
Formula question
Fri, 3 Oct 2008 13:42:05 -0700
I am trying to find a formula that will advance the numerical value of a cell
by 1 when I print a document - its for an invoice template, so that the
invoice number advances. Because I have a number of worksheets in this
workbook, I would want them all to advance by 1 when I print.
Help! ...
|
difficult formula question
Fri, 3 Oct 2008 13:14:01 -0700
I am trying to write a formula & am stuck on the last part.
If the value of M10 is less than zero, then I wan "no order" to display.
If the value of M10 is greater than zero, then I want the lesser value of
L10 & J10 to display.
Here is what i have thus far =If(not(m10>0), "no order",
I don't know how ...
|
