# Formulas : NEED IDEA LO!

• hello there,

i got this sheet with messy letters...:biggrin:

As the 'Expected Answer' label suggest, well that is the answer! the first column reveal the what is "X" in the second col. well, it is a bit tricky here, whenever there is an "X" after either "T" or "F" in second col, then the FOLLOWING TWO must have to be empty or "0" (the answer). then just follow as usual in first col.

so... i think i explained clearly. Sorry if i make it not clear.

any idea??

big thanks!

:o

• Paste this in cell "C3"

=IF(AND(OR((B3="X"),(B2="X")),NOT(C2=C1)),0,IF(B3="X",A3,IF(A3=B3,A3,"F")))

Logic:

IF
1. B3 or B2 is "X" (Cell besides or above the cell besides)
AND
2. the two cells above the result cells are not equal

Result = 0

Else

formula.
end if

Hope this helps, if not, please clarify the conditions... cheers

Thanks: ~Yogendra

• hi 'yjoshi',

oh, Thank You for your 'complicating' formula! :biggrin: !

i got this sheet again, some error still, see i modified a little, but one error still unsolved, can you help me please?

i check if there are 3,6,9 "X" continuously, the answer ain't right. see i think the error continous for 12, ...14 also or 13, ...16,19 i don't know?. but please, can you think of something??

thanks a lot

• oh well "yjoshi"

i got it solved like this, but still can be improved though, you got better idea??