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
Running Windows 7 SP1 (32-bit), Office 2010, Oracle Client 11g, and two System DSNs that point to Oracle databases. I can resolve both ODBC conenctions via a command prompt and tnsping, and I can connect to the ODBC connections via TOAD for Oracle.
Where I'm stuck is that when I attempt to connect within Excel / Power Pivot, it returns a TNS listener error. The issue is user specific as I can switch users and connect via Excel with no issues. Looking for a user-specific setting, registry setting or even a cache setting that may store this info.
Fuel
