Excel Tips - Multiply Formulas By 100

I found out how to make INDIRECT formulas to work with combo boxes

Go to insert>define names>
name anything you want
under the refer to box, insert the indirect formula
let's say if I name it "test"

now click on the combobox, click on properties>

in the ListFillRange box type in "test" (without quotes)



Currently I can only make it to work for 1 row only
=INDIRECT(B2) >>> Test1
=INDIRECT(B3) >>> Test2????
=INDIRECT(B4) >>> Test3????
=INDIRECT(B5) >>> Test4????

So if anyone can improve it further, please let me know!
Thanks!

Wow, thanks everyone for your help with the vlookup command. With a bit of messin around, not only did it work, but now i UNDERSTAND it. THANK YOU SO MUCH.
Now, another question. Now that the vlookup formula works, I am having problems with my "raw" invoice showing #n/a in both the item description column, unit cost column and total column. Is there a way to "hide" the cells with #n/a it without losing its functionality?


Thanks again everyone in advance for your help. And I do apologize for the rookie questions.

Matt

Wow, thanks everyone for your help with the vlookup command. With a bit of messin around, not only did it work, but now i UNDERSTAND it. THANK YOU SO MUCH.
Now, another question. Now that the vlookup formula works, I am having problems with my "raw" invoice showing #n/a in both the item description column, unit cost column and total column. Is there a way to "hide" the cells with #n/a it without losing its functionality?


Thanks again everyone in advance for your help. And I do apologize for the rookie questions.

Matt

I've been trying to figure this out, but it's giving me wrong results.

For example, if the number is 100,000,000 (L6), I need the first 10,000,000 to be multiplied by 0.07 and the 10mill to 50 mill within it to be multiplied by 0.05. 50mil to 75 mil is to be multiplied by 0.035, and the remaining 50mil (75mill to 100mill) to be multiplied by 0.0275.

What I have so far is this:
=IF(L6<10000000,L6,10000000)
=IF(L6>10000000,50000000-25000000,L6-AK6)
=IF(L6>50000000,75000000-50000000, L6-AK6-AN6)
=IF(L6>100000000, 100000000-75000000, L6-AK6-AN6-AQ6)

Then you divide the number you get by 1000.

The final result Excel comes up with is 3,925. I should be coming up with 3,250.

Please help.

Thanks for your time.

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

I was trying to create a template for my colleauges and here is what I want to achieve.

Problem 1:
We have 5 admin staff member,
Melissa, Jo, Jenny and Bella and Cindy. And on the Excel spreadsheet, I have a column of Processed by (which will be either the names of these 5 ladies). How do I build in this names so that nobody will use other names rather like Mel or Joanne or Jen or Candy (wrong spelling anyway) in that excel spreadsheet? (I was manually typing those names, select the names, used data-data validation-list)- didn't work very well because I don't want the names to show up when they first started off that spreadsheet.

Problem 2:
I have plugged in some formulas in my excel spreadsheet. I want my formulas to remain there, but I don't want any figures such as 0, #N/A s to appear until figures in the appropriate columns are filled in. How do I make the result/formula invisible?

Resolving will help me solve the initial problem and keep me going on my template. Your help is greatly appreciated.

If you have any tips or tutorials that you would like to see, or add to
my blog, please visit me at http://teachr.blogspot.com and let me know.