desoriente
New Member
- Joined
- Dec 31, 2010
- Messages
- 14
I need to one formula that gives me the following returns based on 3 criteria.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
Criteria #1
If the sum is greater than zero (0), then return the average.
<o
> </o
>
Criteria #2
If the sum equals zero (0) and the letter T is NOT present among the sum, then return zero (0).
<o
> </o
>
Criteria #3
If the sum equals zero (0) and the letter T is present among the sum, then return the letter “T.”
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Criteria #1
If the sum is greater than zero (0), then return the average.
<o


Criteria #2
If the sum equals zero (0) and the letter T is NOT present among the sum, then return zero (0).
<o


Criteria #3
If the sum equals zero (0) and the letter T is present among the sum, then return the letter “T.”