simplify a large formula
"T. Valko" wrote:
If you could explain what you're wanting to do we can probably shorten that
formula as well.
What kind of data is entered in columns C, D and F?
What kind of data is entered in F13:F23 ?
What's in AC1 and AC2 ?
You'd be surprised what we can do when we know the details!
--
Biff
Microsoft Excel MVP
this is a presence table to determin the amount to pay
basicly the people enter a "X" on this colums C, D and F the value is in AC1
and AC2 (9 and 19) also if there are a "X" on F13:F23 a prime of 35 is ad,
N14:Y14 are the days of attendance they can be a "P","M" or "F" (p and m = 1,
f = 0)
Tks
|