software

I am completely confused.
H represents a staff member on Holiday.
I have a total number of staff and want H to represent -1.
If H is entered in any of the range of cells selected it must represent -1
and be able to be included in a formula.
Please help.

On Tue, 14 Mar 2006 08:19:26 -0800, Guybon Berry lt;Guybon
gt; wrote:

gt;I am completely confused.
gt;H represents a staff member on Holiday.
gt;I have a total number of staff and want H to represent -1.
gt;If H is entered in any of the range of cells selected it must represent -1
gt;and be able to be included in a formula.
gt;Please help.

You might be able to incorporate a COUNTIF function in your formula:

=Staff_Numbers - COUNTIF(rng,quot;Hquot;)--ron

Don't do it that way. It can be done, but you can be sure you'll get yourself into trouble some time.
Use an extra cell (which you can hide) with a formula like

=IF(A1=quot;Hquot;,-1,quot;YesWhatElsequot;)

YesWhatElse: you didn't specify

--
Kind regards,

Niek Otten

quot;Guybon Berryquot; lt;Guybon gt; wrote in message
...
gt;I am completely confused.
gt; H represents a staff member on Holiday.
gt; I have a total number of staff and want H to represent -1.
gt; If H is entered in any of the range of cells selected it must represent -1
gt; and be able to be included in a formula.
gt; Please help.