Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make H = -1 on a worksheet, yet show H?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make H = -1 on a worksheet, yet show H?
On Tue, 14 Mar 2006 08:19:26 -0800, Guybon Berry <Guybon
wrote: 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. You might be able to incorporate a COUNTIF function in your formula: =Staff_Numbers - COUNTIF(rng,"H") --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make H = -1 on a worksheet, yet show H?
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="H",-1,"YesWhatElse") YesWhatElse: you didn't specify -- Kind regards, Niek Otten "Guybon Berry" <Guybon wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shaded cells on a worksheet but do not show up on printed copy? | Excel Worksheet Functions | |||
How do I make a worksheet my start page? | Excel Worksheet Functions | |||
How to show query parameters on an Excel page header or worksheet? | Excel Discussion (Misc queries) | |||
can I make worksheet name equal a cell | Excel Worksheet Functions | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) |