Functions
in [Excel]
|
Copying text from multiple cells. I have a seven spreadsheets (by day of the week and one consolidated sheet) that keeps track of how many hours a student misses in a week. Calulating the time on a consolidation sheet is no problem. I am trying to combine any Text (reason for absents) into one cell for that student on the consolidated sheet ... 16 May 2010 17:56
evaluate No, I don't see how that could ever be True. -- Rick (MVP - Excel) "afdmello" <afdmello(a)hotmail.com> wrote in message news:eXrWFES9KHA.3840(a)TK2MSFTNGP02.phx.gbl... I saw a worksheet for training programs in which this formula is written =IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1)) can the function... 16 May 2010 16:51
Tables in excel- bringing down formulas for new records. I am trying to put together a table and want to have an auto number that counts the recods and puts the next number in for a new record. Need a good method to do this and to have it automatically carried down when a new record is created. I also have a formula that calculates interest on a principle amount. ... 18 May 2010 20:21
evaluate I saw a worksheet for training programs in which this formula is written =IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1)) can the function C6>EDATE(C6,12) can ever be true as the logic is refering to the same cell afd ... 16 May 2010 14:39
FORMULA??? I AM TRYING TO ORGANIZE SOME DATA VERTICALLY BUT IS ALL HORIZONTALLY... FOR EXAMPLE: THIS IS WHAT IT LOOKS LIKE A B C 1 TIM MAY 3 12 2 MATT APRIL 3 15 3 WAYNE DEC 16 24 IS THERE A FUNCTION WHERE U CAN CHANGE IT TO ... 16 May 2010 12:27
Excel xscx Bet wrote: Excel 2007 Error message when trying to record Macro 13-May-08 I recorded a macro. I decided that I did not want the macro to perform the final function that I had recorded. I deleted the last couple of lines of code in the macro. Ever since then, when I try to record a new macro to b... 16 May 2010 03:48
How do I auto Expand a cell for printing only? I would like to retain the format of the row hieght for the electronic document. ... 16 May 2010 08:06
how do you have the headings scroll down the page as you move dow How do you have the column headings scroll with you as you work downward on a page ?? Help . . . Bless you for information - much needed ! Thanks ... 15 May 2010 23:32 |