Converting a formula for automatic formatting criteria
I have this formula that works in excel.
=IF(AND($K$2(SUM($U$2*0.8)),$K$2<(SUM($U$2*1.2))) ,"true","false")
And when I try to get it as conditional formatting I get the "not enough or
too many parenthesis" error.
This is what I tried in onditional formatting.
=if(and($k$2<(sum($u$2*.8)),$k$2(Sum($u$2*1.2)))) .
What am I doing wrong or can I not us the and function in conditional
formatting?
BTW, this is the 3rd criteria so don't tell me to split it up (the first two
are between functions)
|