Support Board
Date/Time: Sun, 24 Nov 2024 21:56:42 +0000
Post From: =AND function
| [2013-12-03 01:43:49] |
| User021827 - Posts: 174 |
|
I want to have a second criteria with the and function. I use =AND(crossfrombelow(A3:A4,AA3:AA4),AA3:AA4>0) 1. how can I use > greater than in place of cross from below ? 2. how would I add the second criteria of lets say : AB3:AB4>20 adx is greater than 20 can I use numerical numbers like that or do I have to have them as data in a column ? thanks |