If Function Greater than Less Than

[Sher10]

Hello, I was hoping someone can help me. I am preparing a banking sprea
sheet and I want a comment to appear if the variance is Greater than $
or greater than ($5). I have used the formula

=if(and(m18<-5, M18>5), "PROVIDE COMMENT", "")

I know the formula is close but not quite there.

Can someone please help.

Ie if my variance is $9.60 the cell needs to return "PROVIDE COMMENT"
if my variance is ($6.50) the cell needs to retun "PROVIDE COMMENT

 

[joeu2004]

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, M18>5), "PROVIDE COMMENT", "")

Ostensibly, change "AND" to "OR", to wit:

=if(or(m18<-5,m18>5),"...comment...","")

Alternatively, you could write:

=if(abs(m18)>5,"...comment...","")

 

[Sher10]

Thankyou so much. That worked perfectly.

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, M18>5), "PROVIDE COMMENT", "")-

Ostensibly, change "AND" to "OR", to wit:

=if(or(m18<-5,m18>5),"...comment...","")

Alternatively, you could write:

=if(abs(m18)>5,"...comment...",""