Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 24 Apr 2024 03:08:05 +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 |