If Function Greater than Less Than
Hello, I was hoping someone can help me. I am preparing a banking spread sheet and 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", "")
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"
|