mercredi 22 mai 2019

Does anyone know which part I made wrong?

I made a conditional formatting in google sheet, however, after I modified my case from first attempt to second(as shown), the original true result turned false, any ideas? Thanks.

E4 is not blank.

=and(D5<Q6,E5>T6,
rounddown(mround((R5+T5)/2,0.001),2)>mround(R5/1.014,0.01),L5>1,
if(isblank(E4),
E3<mround(R5/1.014,0.01),
E4<mround(R5/1.014,0.01)
)
)


=and(D5<Q6,E5>T6,
if(isblank(E4),

and(E3<mround(R5/1.014,0.01),
or(
and(rounddown(mround((R5+T5)/2,0.001),2)>mround(R5/1.014,0.01),L5>1),
abs((R5-E3)/(E3-T5))>1)
),

and(E4<mround(R5/1.014,0.01),
or(
and(rounddown(mround((R5+T5)/2,0.001),2)>mround(R5/1.014,0.01),L5>1),
abs((R5-E4)/(E4-T5))>1)
)

))

Aucun commentaire:

Enregistrer un commentaire