|
|
|
December 8th, 2005 06:12 PM
by Wolmot
|
4 |
117 |
|
|
Changing the colour of a logic expression by
cjrrussell
Hey guys
I have this logic expression in a spreadsheet
=IF(C19C18,"YES","NO")
What i want to do is if it returns a value of NO make the text red.
Is this...
|
|
4 |
166 |
|
|
Excel If Statements, please help! by
izzie
I've been trying to make multiple IF statements but it says that I have
too many arguements. The problem is, I need to have a calculation for
my work.
Here's...
|
December 8th, 2005 08:36 PM
by JR
|
4 |
167 |
|
|
Conditional Formatting by
Ant
I have a workbook where I would like to apply conditional formatting to an
entire row, depending on the condition in the first column. I know how to
apply the...
|
|
4 |
270 |
|
|
Splitting the contents of a cell? by
Dan B
Hi,
I have several columns of data that contain data such as:3001001E:Name
I want to keep what is on the right side of the colon. How could I do this
with...
|
December 8th, 2005 08:34 PM
by Dan B
|
4 |
135 |
|
|
Conditional Formating by
Trying To Excel
=A1=MIN($A$1:$C$1)
click format and select red font, click OK twice
Can I copy or expand this to include al the cells down to A25,B25,C25
|
|
4 |
215 |
|
|
Date formula needed by
Rich Hayes
Hi
If in cell A1 I have a month name for example: 'January'
In cell D1 i want to say, if the month in cell A1 says 'January' then add a
month and show...
|
|
4 |
103 |
|
|
Formulas in Excel XP by
Rebecca
Trying to insert a 5% price increase into a range of cells. I.e. - customer
price list will recieve a 5% increase... Is there any way to to insert a
formula...
|
December 9th, 2005 04:52 PM
by Rebecca
|
4 |
139 |
|
|
|
December 9th, 2005 08:25 PM
by Valerie
|
4 |
119 |
|
|
US dates to UK?? by
Bill
I have an Excel 2003 spreadsheet that has a column full of dates. I have no
control over how the spreadsheet has been configured.
The dates are in an American...
|
December 8th, 2005 06:44 PM
by vezerid
|
4 |
274 |
|
|
formula I can't figure it out?! ARGH by
jewels
I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either? Here
is what...
|
December 8th, 2005 01:04 PM
by jewels
|
4 |
131 |
|
|
|
|
4 |
213 |
|
|
Maybe I need help with Lookups?? by
garry05
Hi all...a newbie here.
I'm okay with many Excel functions, but I don't go too deep: Can't do macros, lookups, that sort of thing.
Here's my dilemma: ...
|
December 8th, 2005 02:26 AM
by Max
|
4 |
161 |
|
|
Countif, then multiply?? by
Gee-off
A B C
1 S6 B2
I know how to use the countif function as if to count all values that equal
"S*" (value beginning with "S" only regardless of the...
|
|
4 |
130 |
|
|
|
December 9th, 2005 07:34 PM
by Ian
|
4 |
89 |
|
|
Help with if statement..... by
WalterT.
I am trying to create a time sheet for the 15th of the month through the end.
I have an empty column for the 31st (S). I want this header (S13) to be blank
if...
|
|
4 |
108 |
|
|
|
|
4 |
90 |
|
|
|
|
4 |
147 |
|
|
Show blank cell when not Closed or Open by
roy.okinawa
I have this formulas in column B: =IF(AH80,"Closed","Open")
When I copy this formula down column B into blank rows, Open appears in all
those cells below B8...
|
|
4 |
120 |
|
|
Looking for best fit by
Greg
I'm looking for a formula to find the 'best fit' for inventory turns. For
example:
A B C D
1 10 100 50 5
The formula in D1 is: ...
|
|
4 |
98 |