Link to home
Start Free TrialLog in
Avatar of hwassinger
hwassingerFlag for United States of America

asked on

Condions in Excel

I have a spreadsheet that I need to do some review on on an ongoing basis. Is there any way to do complex conditional formatting ...

if k1 = k2 and timediff of (c1 & h1) - (c2&h2) <=60 and g1 = 47 and g2 = 2   then z2=TRUE

NEXT LINE
if k2 = k3 and timediff of (c2 & h2) - (c3&h3) <=60 and g2 = 47 and g3 = 2   then z3=TRUE

And so on through the spreadsheet
5-5-2011-5-15-18-PM.jpg
Avatar of jppinto
jppinto
Flag of Portugal image

Like this?

=IF(AND(K1=K2;(C1+H1)-(C2-H2)<=60;G1=47;G2=2);"True";"False")

jppinto
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please check the attached file I've made for testing purpose.

jppinto
Formula.xls
Avatar of hwassinger

ASKER

When I poaste the formula into a cell it only displays the formula, not the TRUE as your exanple did, what am I missing?
If it is only displaying the formula in the cell then you have probably missed the equals off the front of it (=IF(An......)