excel formula question...
Chuck in Mtl.
in the following excel if statement what is the purpose of the exclamation mark...
=IF(Edit_Equipment_List!B230="","",Edit_Equipment_List!B230)
Knowledge You Can Build On — Est. 1998
excel formula question...
Chuck in Mtl.
in the following excel if statement what is the purpose of the exclamation mark...
=IF(Edit_Equipment_List!B230="","",Edit_Equipment_List!B230)
Re: excel formula question...
mdclor
If I am understanding your question correctly, that indicates that the preceding is the name of the page in your spreadsheet where the referenced cell resides.
Re: excel formula question...
Bob
=IF(Edit_Equipment_List!B230="","",Edit_Equipment_List!B230) My understaning is it is looking to compair the values of B230 in another tab. "" is a true or false I belive. Hard to say without seeing the whole picture
Re: excel formula question...
Bob
But yes it denotes another tab.
Re: excel formula question...
Brad Chenoweth
The exclamation point locks in the cell number B230, even if the spreadsheet is changed and the information then resides in a different cell.
Re: excel formula question...
Chuck in Mtl.
Thanks for the answers, what was confusing me was the overall logic of how the entire excel file was organized. it was one of those "oh yeah" moments. thx again.
Years ago...
Ellis Walentine
... when I was actually using Excel on a regular basis, a friend of a friend published a book called "Excel Annoyances," of which there were many in those days. I'm amused to hear that they're still up to their old tricks. 
Ellis
Re: Years ago...
Stuart Johnson
At one time Lotus was the king. There was a magazine published called of all things "Lotus". Each issue had a question listed with the goal being how to set up the spreadsheet or formula. I used to be able to knock them out in no time, then with new updates I started missing them. It finally got to the point where I didn't understand what they wanted as a result let alone how to arrive at the solution.
FWIW, at one time I used to be able to multiply on a 10 key adding machine and had a Monroe 100 key machine to calculate bond yields and amortization. Now I need to work at figuring the best buy at the grocery store.
Speaking of Excel, I've been wanting to ask
Gary Smyth
Two problems. Problem #1. I have two sheets, one with a little over 1300 lines and one with 827 lines. When I print the sheets both want to print 2500 lines which means I have pages of Excel grid with nothing in them. I've taken to printing by printing "pages" and the number, say "22" and "9". That way I print only the cells that have data in each of the sheets. I've tried everything I can think to do and still if I just push "print" it prints 2500 lines no matter what/how I try to limit the printing only to the cells with information. There has to be a easy way to print the full sheet limited to only the cells containing information? I haven't discovered the shortcut. Excel help is useless to me as I do not know how to describe the problem in a few words. I'm missing something. Is there a formula or a selection?
Problem #2. I have books entered into Excel by title, author, publisher, cost, location. My master sheet is in alphabetical order by title, but I have had little success rearranging the sheet in alphabetical order by the other columns. How do I do that, say once every three months, but still retain a sheet alphabetized by title for everyday use?
Not a guru, but
Ellis Walentine
... for Problem #1, you can use the File > Print Area > Set Print Area to outline only those cells you want to print. For problem #2, you want Data > Sort. From there you can choose which column(s) to sort on and whether you want to sort ascending or descending.
Ellis
Re: Speaking of Excel, I've been wanting to ask
mdclor
Gary, re Problem #2: Copy your master to a second sheet (tab). Click on any of your column headings so that that cell is the active cell, then right click on the same cell. Select Sort from the drop down menu and finally select sort A -> Z. Let me know if further questions.