Pages

Search

Excel Help Forum - Excel General: If value is missing in any column, then cannot perform operation

Feed2Mail notification - new post on Excel Help Forum - Excel General
If value is missing in any column, then cannot perform operation
Hi, i need some help in figuring out this formula: in cell H3 i have: =SI(D3="","",D3-(E3+G3+C3)) but i want to see if there is missing value in C3 and/or D3 then the formula will output "Missing Value" instead of perfroming the operation. I have attached the excell sheet. Please help ,...

Office IT Pro General Discussions Forum: Sharing your calendar with specific people

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Sharing your calendar with specific people

the client would like to share his calender with his secretary and also be able to hide certain meeting from her.

CAn you please she me how to do this in step by step form please(step1,step 2,step 3, etc.)

Excel Help Forum - Excel Programming / VBA / Macros: VBA transfer data from one workbook to another

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA transfer data from one workbook to another
how would i go about transferring data from one workbook to another? the starting data is in: workbook: "VEF LOGBOOKm working.xlsm" worksheet: "Finished" cell: b1 I need it to go to the first unused cell in column a in: workbook: "VEF SUMMARYm.xlsm"

Excel Help Forum - Excel General: Calculating the number of days which fall in financial year

Feed2Mail notification - new post on Excel Help Forum - Excel General
Calculating the number of days which fall in financial year
Hi All, Anyone know how I could split the number of days beween two dates by financial year? ie From To Amount Number of days which fall in 2011/12 financial year Number of days which fall in 2013/14 financial year invoice...

Excel IT Pro Discussions Forum: Excel 2010 - complicated formulas

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2010 - complicated formulas

Hi

I have a spreadsheet I'm just about happy with, but I need to tweak a formula slightly and I need a bit of help with it. In the cells in column F, the user either types in the Book Band number or if the child has reached above level 30 they are now a Free Reader and they typre Feee Reader into a cell in column F. A Free Reader has the reading age of someone 11y, 6m+.

In column G the formula works out how far ahead, behind or whether they are on target. Here is the formula:

=IF(TRIM(E2)=TRIM(G2),"On target",IF(INT(M2)<>0,INT(M2) & "y, ","") & ROUND(MOD(M2,1)*12,0) & "m" & IF(K2>L2, " behind"," ahead"))

I would like to adjust that formula to show the text in column H of "Way ahead" if a child is a Free Reader (11y, 6m+).

I'd really appreciate your help.

Viv

Viv Haig

Excel Help Forum - Excel Programming / VBA / Macros: Weighted Random Number Generator Code Needed

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Weighted Random Number Generator Code Needed
Hello, I am running an excel based Jeopardy game and need a way to randomly choose three winners based on their number of entries gained throughout the game. I need a code which is able to take in columns of information (example below) and randomly pick three student numbers, taking into...

Excel Help Forum - Excel General: How to copy a formula to multiple cells without filling blanks cells too..

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to copy a formula to multiple cells without filling blanks cells too..
Hi, I'm attempting to use a concatenate formula on a list of keywords, however some of the keywords are blank. Is there any way I can get my concatenate keyword to not appear in these fields. I'm attempting to insert a '+' symbol before every keyword but I have 8000+ keywords. E.G. ...
Subscribe to: Posts (Atom)