|
|
120= rupees one hundred twenty only by
digit to text
i just want to know the formula which translate digit to text for example if
120 written in any cell and other cell we want result "rupees one hundred
twenty...
|
|
2 |
314 |
|
|
|
|
0 |
360 |
|
|
month name by
pat67
There is a function to show the number of the 1-12. Is there a way to
show the name?
|
|
4 |
317 |
|
|
Lock in formulas by
Malcolm
I have a worksheet that I use over-and-over again. It has several columns of
data, and some of the columns have long and hard to remember formulas to
total...
|
|
2 |
341 |
|
|
Excel 2003 Function Help by
Ryan Hicks
I need help coming up will a function that will average a range in one column
based on if the hours match. Here is my set up.
-------A-------B...
|
|
4 |
336 |
|
|
find the correct sum by
reza
HI EXPERTS,
i hope you and excel can do this.
i have a master data with so many rows.
i.e A B C D
No Name ...
|
May 25th, 2010 12:22 AM
by Max
|
8 |
413 |
|
|
sum the color cells by
reza
hi all.
i have data with different color.
i one column i have 3 color, blue, yellow and red.
now i want to count & sum based on the colors.
how to create...
|
|
7 |
611 |
|
|
|
|
2 |
253 |
|
|
|
|
4 |
224 |
|
|
|
|
1 |
232 |
|
|
Principal & Interest Formula by
Scoober
Hi all,
I am trying to complete a principal & interest formula that remain empty in
the target cell if no loan amount is...
|
|
1 |
336 |
|
|
How to sum by month by
Charles
I have a sales order spreadsheet that gets updated daily from our ERP system.
The worksheet has the following columns:
1. Customer code (each customer could...
|
|
8 |
445 |
|
|
Button on Form to Add more rows by
SaM
I have a form that I have created in excel and in one section of that form, I
want to be able to add a button that will add 5 more rows for that specific...
|
|
1 |
303 |
|
|
|
|
4 |
312 |
|
|
Count number of rows with specific text by
Rock
I am using this formula to count the number of rows in Column C with text.
=SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500)))
I need, instead, for this...
|
May 24th, 2010 08:46 PM
by Rock
|
2 |
288 |
|
|
personal.xls by
pat67
Random question. for some reason my personal.xls file does not open
when i start excel. it was now it isn't. for some reason i have to go
into the folder and...
|
May 24th, 2010 08:23 PM
by pat67
|
3 |
263 |
|
|
Two Condition - search by
linda
I am trying to pull value when two conditions are met.
want to count column "B" when it = "ETARC" and when column "J" is = "0" or a
negative number.
I...
|
|
2 |
203 |
|
|
if true, if not nested if funcion by
Cali
Having some trouble figuring out a formula. Hope someone can help!
This is going to go into Cell B10.
If cell b7 is =equal or greater than the value in B12...
|
May 24th, 2010 07:15 PM
by Cali
|
2 |
214 |
|
|
|
|
1 |
237 |
|
|
Yes - No Fill-ins & More by
DisMusBeDaPlaz
Working in Excel, I am looking for help using fill-in boxes.
I am creating a form.
Setting up a cell or a bunch of cells merged where you can enter a...
|
|
0 |
195 |