If Function Greater than Less Than
"Sher10" wrote:
I want a comment to appear if the variance is Greater
than $5 or greater than ($5). I have used the formula
=if(and(m18<-5, M185), "PROVIDE COMMENT", "")
Ostensibly, change "AND" to "OR", to wit:
=if(or(m18<-5,m185),"...comment...","")
Alternatively, you could write:
=if(abs(m18)5,"...comment...","")
|