LinkBack URL
About LinkBacks
Leave out the " marks
=AND(M6>"0.1",M6<"0.51") You're comparing M6 with text.
=AND(M6>0.1,M6<0.51) now M6 is compared with numbers
try it and get back if you still have problems.
cheers
Leave out the " marks
=AND(M6>"0.1",M6<"0.51") You're comparing M6 with text.
=AND(M6>0.1,M6<0.51) now M6 is compared with numbers
try it and get back if you still have problems.
cheers
Perfect - thanks Teylyn!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks