|
|
IF formula returns FALSE by
Gulfman100
The following formula returns FALSE when the first IF (B3=9)condition is not
met. I
want to return a blank cell or a 0. The other 2 IF formulas are working...
|
February 8th, 2009 11:31 PM
by Max
|
1 |
213 |
|
|
IF FUNCTION by
Gulfman100
he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))
Works well if the first condition...
|
|
7 |
198 |
|
|
copying formulas by
Gulfman100
I copied the following formula to another cell:
=INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber
Gabel Roof'!B18,BoardLength,0))
In...
|
|
5 |
189 |
|
|
|
February 8th, 2009 08:16 PM
by Paul
|
1 |
183 |
|
|
Pence per mile by
Double_R
Hi all,
I am a sole trader and want to calculate my car running costs in Pence per
mile taking into account fuel, servicing, tyres etc. I have looked at the...
|
|
1 |
190 |
|
|
Track Changes by
nin157
HI,
I have a lot of data on one spreadsheet. Is it possible to track/highlight
my changes before I save without Sharing the spreadsheet??
|
February 8th, 2009 07:16 PM
by nin157
|
0 |
145 |
|
|
Compile error by
George Gee
Hi all
I've received a worksheet from a colleague, when trying to run a macro,
I get a compile error - 'Cannot find project or library'
Code stops at ---...
|
|
2 |
160 |
|
|
|
|
0 |
157 |
|
|
|
|
0 |
348 |
|
|
|
|
0 |
194 |
|
|
|
|
0 |
125 |
|
|
|
|
0 |
115 |
|
|
|
|
0 |
184 |
|
|
|
|
0 |
122 |
|
|
Row Insertion Problem by
robot[_4_]
Hello,
I have a worksheet with a hidden column of formulas, each formula making
calculations using data on the respective row.
It is fine until a user...
|
February 7th, 2009 04:38 AM
by Jon
|
2 |
130 |
|
|
Reminder notification for training by
femfrog
Hi,
I was asked to create a spreadsheet to keep track of training for employees.
The employees have to complete a training session every six months. The...
|
February 7th, 2009 04:35 AM
by Jon
|
2 |
166 |
|
|
Deleting rows based on column values by
Dazed and Confused
Have a spreadsheet with 30,000 rows. I need to delete rows that have
specific column values, for example:
Column A = 61
Column B = 60-67
Column C =...
|
February 6th, 2009 10:47 PM
by Max
|
3 |
179 |
|
|
|
|
2 |
143 |
|
|
|
|
2 |
131 |
|
|
Count partial matched text string by
Chapi
I have 3 spreadsheets. The first, “Supplies Requests Received” where Column
B contains the (duplicated) names of internal offices placing supply requests...
|
February 6th, 2009 01:24 PM
by Luke M
|
4 |
134 |