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