| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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...","") |
|
#3
|
|||
|
|||
|
Thankyou so much. That worked perfectly.
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SMALL function to find X smallest number greater than Y | Excel Worksheet Functions | |||
| Greater than less than in a find function | Excel Programming | |||
| What is the VBA function to return the greater of two integers? | Excel Programming | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
| Less than Greater than function | Excel Worksheet Functions | |||
Linear Mode
