About Us

Nikky

Thank you very much! It was extremely helpful.

"jamescox" wrote:

I copied your table of info into a worksheet starting at cell A4, so
that gives you some idea of how to adjust the cells in the formulas.

For High Med Low = 3,2,1 conversions use the following:

=IF(UPPER(D4)="HIGH",3,IF(UPPER(D4)="MOD",2,IF(UPP ER(D4)="LOW",1,"")))

For Low High Stable = 1,1,0 conversions use:

=IF(OR(UPPER(G4)="LOW",UPPER(G4)="HIGH"),1,IF(UPPE R(G4)="STABLE",0,""))

For N Y = 0,1 conversions use:

=IF(UPPER(E4)="N",0,IF(UPPER(E4)="Y",1,""))

For highlighting cells if the training is more than two months in the
past, use the following formula in a Conditional Formula:

=EDATE(B4,2) < TODAY()

Some comments:

1. These formulas could be placed in a group of cells to the right of
data entry area (Columns A through H)

2. The conversion formulas are a bit more complex than they might have
to be, but use UPPER to make sure 'mod', 'Mod', 'MoD', 'MOD' and all
such variations are recognized.

3. You could use Data Validation to put a drop-down arrow in each data
entry cell which would allow the nurses to just select an entry and not
require them to type anything.

Hope this helps...

--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113743

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Giving "X" a numerical value.	floyd.anderson	Excel Worksheet Functions	7	December 12th 08 10:29 AM
Giving letters a numerical value, then adding the total.	Richard in Stockholm	Excel Discussion (Misc queries)	17	April 9th 08 05:01 PM
Giving a letter a numerical value	Mullet2262	Excel Discussion (Misc queries)	6	March 9th 06 01:23 AM
Easy (?) questions for setting up a database	roger_home	Excel Discussion (Misc queries)	3	February 11th 06 05:47 PM
Giving Months Numerical Values	luvthavodka	Excel Discussion (Misc queries)	1	December 9th 05 10:56 AM

Menu

About Us