|
|
Showing Error when going to pass a function like this by
Brahmananda Mohanty
=IF(C2=1,"Ten",IF(C2=2,"Twenty",IF(C2=3,"Thirty",IF(C2=4,"Forty",IF(C2=5,"Fifty",IF(C2=6,"Sixty",IF(C2=7,"Seventy",IF(C2=8,"Eight",if(c2=9,"Nine",0))))))))
why...
|
|
1 |
99 |
|
|
|
|
1 |
1,103 |
|
|
|
|
1 |
130 |
|
|
post positive sum as a negative? help! by
Brainless_in_Boston
Good ole microsoft... I have entered 2 positiive numbers in sequential cells
in a column, however, I want to display their (positive) sum as a negative,
so I...
|
March 24th, 2006 08:19 AM
by Marijus
|
1 |
147 |
|
|
search for help? it sucks by
Brainless_in_Boston
#1 I don't want to "Select a Discussion Group" (accordingly, since I MUST, I
will post to a bunch of discussion groups and hope against all hope that...
|
March 23rd, 2006 04:52 PM
by Biff
|
1 |
80 |
|
|
use COUNTIF to total BOLD TEXT?? by
Brainless_in_Boston
I am auditing a list of subscribers (for their Dental benefit), and
highlighted (in BOLD text) the ones I need to research. I want to count the
cells with BOLD...
|
|
4 |
92 |
|
|
|
|
2 |
68 |
|
|
Hide #Value! by
brainstewn
=IF(H38=0,"",(($C59+C60)/$H38))
I've read the techniques for hiding the #Value! when empty but need help. I
tried doing it with ideas in the forum but it's...
|
October 17th, 2009 03:52 PM
by Kassie
|
3 |
117 |
|
|
|
|
2 |
145 |
|
|
Need help with a forcasting type problem by
Brake-Man2008
I am trying to have excel do a few automatic calculations for me. In the
problem I am trying to solve I have the following:
Given:
Month (day...
|
|
5 |
72 |
|
|
What does Excel's RAND function really do by
Brakeshoe
I am trying to match a clients spreadsheet where they are using RAND() to
generate values for the cumulative inverse standard normal distribution.
According...
|
|
4 |
177 |
|
|
AVERAGE (But only IF) by
Brampton76
I have 4 named Columns, for simplicity they a Code, Red, Blue and Green.
In the Code Column are the numbers 1,2, or 3 and are random. The Red, Blue
and...
|
|
6 |
50 |
|
|
|
|
2 |
62 |
|
|
|
March 14th, 2007 07:45 PM
by bran100
|
2 |
72 |
|
|
|
|
1 |
55 |
|
|
"#N/A" -- can I convert to a "0" (zero)? by
Branchie
I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the
cell. ...
|
|
2 |
75 |
|
|
|
|
1 |
154 |
|
|
Section Breaks by
Brand33
Is there a function for section breaks in Excel as there is in Word that gives you the ability to changes fonts, margin sizes, etc. in the new section?
|
|
2 |
401 |
|
|
How do i Use actual number displayed? by
BrandenKilgore
I'm working on a spreadsheet with a lot of referenced formulas. I have
it set to where, for example, .08*19 displays the answer "2" because I
have it with no...
|
|
2 |
219 |
|
|
|
January 27th, 2005 09:15 PM
by Brandi
|
5 |
446 |