Alternate Function to "Match" or "Lookup"

[zephaerie]

Here's the deal:
There are three fields (E,F, &G) affected by two ranges of information, A:B and C.
Field E is (=IF(SUM(H23:H30)+SUM(H61:H81)=0,"0"; IF((SUM(H23:H30)+SUM(H61:H81))>=8, 8,(SUM(H23:H30)+SUM(H61:H81)))
Field F is (=IF(Sum(A:B+C)>8, (Sum of A:B+C)-8, "0")

The formulas I have tried are:
Field F is (=IF(AND(Sum(A:B+C)>8, (Field G)=FALSE), (Sum of A:B+C)-8, "0")
Field G is (=IF(MATCH(OR("T","V"), C, 1), SUM(A:B+C)-8, "0")

I also tried (MATCH(OR("T","V"), C, 0); (MATCH(OR("T","V", C, -1) and the Lookup function.

What is needed is a function that will perform the specified task without calculating an error when the function for Field G is false. If anyone has any suggestions, please let me know.

 

[mscallisto]

You either have to fix your data OR preceed the formula with "= IF(ISERROR(etc.

 

[schat]

hi zephaerie
i think the "" s in your if statements are causing the problem. they're forcing the 0 to appear as text format not number format. just curious - did you post the same q on mr excel? looks familiar.
hth
schat

 

[zephaerie]

Schat, this is the only question I've posted on this subject. I'm sure many people have had similar problems though. I also tried just putting 0 as the placement for when the statement is false. The problem is with the actual function, which returns an error when false.