Search
Excel Help Forum - Excel General: If value is missing in any column, then cannot perform operation
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
Excel Help Forum - Excel General: Calculating the number of days which fall in financial year
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
Excel Help Forum - Excel General: How to copy a formula to multiple cells without filling blanks cells too..
Danh sách blog
1. Thông Tin Địa Điểm Trường Học Thuộc TpHCM
2. Tìm địa điểm ** Chính xác** Bản đồ,số ĐT,website
3. ATM Agribank, bản đồ, địa chỉ, đường đi
4. ATM Vietcombank, bản đồ, hướng dẫn đường đi đến Địa điểm
5. ATM Sacombank, bản đồ, hướng dẫn đường đi đến Địa điểm
6. ❤ ❤ Dịch vụ chọn lọc cho bạn ❤ ❤
7. Sửa lỗi
8. Đầm bầu
9. Top nice templates for you
10. Top answers for your issues - collect information from Google Search
11. Top Clips Vui Nhộn
12. AngularJS Tutorials
13. Lời bài hát